Hi have a multi-worksheet spreadsheet file that I would like to chart. Each worksheet has data for 1 month and looks something like this:
a b c d e f g
I'd like a several line graphs with multiple lines on each graph (1,2,3,4,5). X-axis is the month, Y-axis is the data in a (first chart) b (second chart), c(3rd chart, etc). There are 7 data points (a,b,c) and I currently have 12 months of data (worksheets). Here's the thing - I'd like it set up so I can add more data to the spreadsheet (additional months) in the future with minimal formatting and add that data to the graph.