I have a 10meg file with data on 10 separate tabs. Each tab or sheet has about 5-10 graphs.


Data is column 1: date, Column 2 through ….. is data (numbers)

Goal is to reduce the size and have a nicer way to graph. I can graph every combination and have hyperlinks to each one but that may take alot of time and a very large file. Would be over 50meg when done. I have data (dates, density, viscosity, weights, etc all vs dates on each sheet)

Would I would like to do is have a few columns with labels and have one graph. So if I selected one column (that would be the x , usually always date, and if I selected the other column that would be the y1 and y2 ). I was hoping to make a list of all columns from all tabs (sheets) then make label for each label in a pull down menu. So I would need the same data or labels (which would refer me to a set of data) for 3 columns. I will always be plotting date vs y or date vs. y1,y2. I see this a lot of times on the internet so I know it can be done.

So instead of having hundreds of graphs I could only have one interactive graph. I have use excel a lot and even have SPC graphs. But would be very nice to be able to plot anything quickly on one plot and to auto scale them. I know we did this years ago on Labview and worked great but all the data is already in Excel and would like to use #Excel for it. Our customer is using jump and mintab.
So all I want to do is pick or cliok onto a label which represents a column of data on a certain sheet then graph it vs another one all vs time (date). Then would be very nice to have buttons allowing me to change labels/scaling, etc..

Is this something Excel can do. I was considering looking into Labview again for this but wanted to keep it simple.

Some of the columns are blank and some have notes and data.

I have the excel file if anyone would like to look at it.

Please feel to email at here:
jerryjaysr@yahoo.com or jerry.jernigan@bp.com

thank you - Jerry

Here are some examples for dynamic/interactive charts. see if it helps. http://peltiertech.com/Excel/Charts/Dynamics.html

I have used it as an example and added alot of data and things.....

It works very nicely. Spent several hrts on it already.

Can I post my work and then ask a simple quesiton. I was wondering if I could add some kind of button to control the scaling and x axis (dates) without going into the chart properties itself.
I am doing x,y,y and looks good except scaling

Jerry

This may help you in your quest to be able to do the dates. not sure about the scale.

http://www.peltiertech.com/Excel/Cha...micLast12.html

This will create a slider with offsets to be able to change a date range on one axis.

HTH.

This is the link for the scrolling data chart.

http://www.andypope.info/charts/Scrolling.htm