Excel Chart Showing Data from Multiple Sheets

Creat a master sheet using the needed data info from each data sheet.

Then plot off the master.

The problem with this is that each sheet has a single days download containing over 40 parameters for each of over 125 control system channels. This makes it a two-dimensional mattrix. By trying to bring in additional downloads, this would make it a three-dimensional mattrix and very unmanageable given the large numbers we would be dealing with.

I am hoping to be able to simply produce a chart that would plot out a cells value from each of perhaps 31 sheets.

As an example, suppose cell AB54 contains the gain for channel 27. By plotting out the cells value from each sheet (sheet1:cellAB54, sheet2:cellAB54, sheet3:cellAB54, ... sheet32:cellAB54), the channel gain over a month can then be viewed.

This is a rather simplified example. For our use we will want to produce charts that contain perhaps six trending lines for various parameters within a control channel.

Add an extra sheet which is set up to draw the required data into a table. Then produce the graph from this.

This is possible by writing small macro.If you are interested we can try.

Thank you. That is very kind of you.

Here are three images of consecutive days on three consecutive worksheets. These show two parameters on each of six control channels.

I would like to be able to plot any one of the parameters onto a single chart while still retaining the information on separate worksheets.

If you are able to produce a chart that can display one of the parameters, it should be fairly easy to replicate that to produce many more.

Thank you again for your efforts.

Please give me some time.I will revert back to you with solution

I have prepared two charts .Please let me know which one will suit you ,accordingly i can write macro

I am not able to paste the picture here.but i can send the file to you provided youremail id is known.

I had sent the picture to you.Please go through and let me know

As promised I have prepared the macro in a separate excel file with data furnished by the poster in a separate excel data file This is sample program I can send it those who are interested

I am interested,*

*CR4 Admin - email address removed

From the CR4 Rules: Do not post phone numbers or email addresses. The CR4 Admin will delete all phone numbers and email addresses posted in threads or comments. You can share this information via the CR4 internal messaging system.

I had sent you the files.Let me have your comments.

I am also in this similar position where I need to create a bar graph from 3 documents which have the same layout but different numerical results. Could I please get a brief explanation on how I would extract data from the 3 different sheets into a single master sheet?

Start a new sheet just for the graph. Link the data from where it resides to adjacent rows in the new sheet, and produce the graph from there. Enter "=SheetName!CellReference" in boxes where SheetName is the sheet where the data is stored, and CellReference is the location on that sheet (D42 or whatever)

Thanks for the swift and detailed reply. I'll post back here when I resume working on this project.