Graph from Multiple worksheets

[rasosa]

I'm trying to make some simple line graphs with information from different worksheets.

I will also be adding more worksheets month by month and this needs to be easily added to the graph... hopefully automatically, if this is a problem then manually. The main issue here is making the graph from diferent wrksheets.

I have attached excel workbook to show what i need. Hopefully someone can help.

Thanx

[Andy Pope]

Keep it simple and build a table of values on the sheet holding the chart, rather than trying to pick cells from all over the place within the chart.

To update all you need to do is enter the new sheetname at the end of the table.

[rasosa]

Thank you Andy, I do know how to do that, but I wanted to make the chart like I said.... I know it is complicated, but I thought there was a way I could do it without doing a MACRO....

Thanks

[Andy Pope]

Confused. There is no macro.

It is simply a table with formula. The chart is linked to the table and will automatically update when the table updates.

To update the chart all you have to do is enter the new sheet name in the first column of the table.