Hi,
I have some Data for the year 2017 & 2018.
What type of chart would be need to compare 2017 to 2018?
Where i am stuck is i want 2017 & 2018 as the Primary and A, B & C as Secondary on the Chart. I know how to use the Primary/Secondary for 2 types of information but cannot get it to work for this scenario.
Also what would be the best Chart to use for this information? [Bar, Line, Pie etc..etc..]
Any help appreciated
Andy
Hi,
Here's a suggestion...
Cheating a little bitte by duplicating your rows of data and using empty cells. Create a combo chart (Bar and Line), set the lines to secondary axis and switch back to bar chart...
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks