I'm trying to add weekly sales data to a chart (attached) tracking monthly count that can't be broken out by week. Ideally, I would have the monthly 2019 and 2020 count as a bar chart and the weekly 2020 sales as a line chart. In the examples I'm finding for combo charts, the data has the same frequency, whereas I'm trying to match 52 records up against 12. Can anyone advise how I do this?
OK, I sort of stumbled into this one.
Right click on the chart and select Selecte Data. Add the weekly data as a third series. Put this series on a secondary axis. THEN you get the option to add a secondary horizontal axis. Select the new series under select data and add the dates to the secondary horizontal axis.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Wow, @dflak, this is great! Can you explain the steps you took to add the weekly data as a new axis? When I tried to replicate, I clicked Add Series, and made the "Sales" column my series but no matter what I tried, it tried to make these sales numbers continuations of my X axis (to where my 2019/2020 counts and sales figures were on the same horizontal axis) - I tried separating onto a second axis but didn't seem to find a solution...
Here is what I did to get the secondary axis.
Select Data is a powerful tool for charting. I call it "getting under the hood."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks