I have the following in one excel spreadsheet:
Headings in Row 24 from column B to column J
Headings in column A starting at row 24 and going to row48
Information for the columns and rows under the headings is collected from information above row 24
This works fine when I am only wanting to graph one lot of data.

However, I then need to use this graph in a yearly graph.

When I do this it doesn't then show what information is from each month.

Can anyone suggest how I can get to the two lots of headings to then also show what month the information is from when I put it into the yearly graph.

Thank you for your time and attention and really hope you can help me out.