Software

Ask something
Discussion Locked

ANALYTICAL SOFTWARE WITH CONTROL CHARTS

0 helpful
3 replies

by txbluebonnet 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

No, these aren't your everyday charts found in MSEXCEL, Harvard Graphics, and such. I am currently using QC (which is an addon for MSEXCEL) that allows some analytical manuevers with stats over periods of time (we are usually comparing through 2 year periods of time flow).

The problem is that QC doesn't allow me to JUST update the charts with the new monthly data; I have to create new charts each month and transfer any unique titles or information from the old chart to the new chart, which is quite cumbersome at times because of amount of charts (ie 200 for one report) I must do each month.... and I am responsible for a number of reports!!!

Any ideas/suggestions?????

Let me know....

K

3 replies

by lo

Might try taking your existing Excel and QC charts, strip the data, save them with just formulas, formatting, etc (different directory or as .DOT files). Create a datastore (external database, flat file, CSV, Access, etc.) for the data. Add / delete data to an datastore as needed (or select from the datastore what needs loaded). Then open the saved empty file or template, import (or otherwise load) data. You should be able to create an Excel macro that would open/select/load the data. Saveto a different directory. Not familiar with QC but ...

by txbluebonnet

LO, your comments seem to be a long way to get to the root of the problem. I am TRYING to look for a quick fix.

Do you realize how much data I have for those charts???? It would take me a while to transfer all that data into something that I wouldn't be certain that there was an option of being able to produce these control charts. They aren't the typical charts that you might find in the Microsoft applications.

Any other ideas...

This discussion is closed to new replies.