I'm not sure how to plot my data. I have three items I want to factor in and chart on it. Vertical titles are in A3:A5 for types, Horizonal titles are B2:D2 for locations, numbers are B3:D5, this is for January. That looks great and I get the chart to look the way I want. Now I need to add additional months through to December. I don't know how to do that wihtout copy/paste the current data 12 times, and just add a monthly title. I want continuous data to show all three axis or data; not 12 seperate blocks of data. Do you know of an easy way to accomplish this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Three sets of data criterea on a chart
- Thread starter techgirl
- Start date
Steve=True
Well-known Member
- Joined
- May 27, 2011
- Messages
- 993
Hi Techgirl,
Based on your description, you may need to change your data layout, but I would suggest that you use a Multi-Level Category Axis.
Check out these two posts:
http://www.exceldashboardtemplates....om-needing-help-on-science-fair-graphscharts/
http://www.exceldashboardtemplates....multi-level-category-label-option-is-missing/
Here is what my sample layout and chart would look like:
Let me know if this helps.
Steve=True
Based on your description, you may need to change your data layout, but I would suggest that you use a Multi-Level Category Axis.
Check out these two posts:
http://www.exceldashboardtemplates....om-needing-help-on-science-fair-graphscharts/
http://www.exceldashboardtemplates....multi-level-category-label-option-is-missing/
Here is what my sample layout and chart would look like:
Let me know if this helps.
Steve=True
Upvote
0
