Howdy folks, been ages since I've been here! Hoping you can help, see attached spreadsheet
I have the following data:
Screenshot 2023-03-05 at 08.43.10.png
From my data I can easily create 2 charts:
- average pieces of fruit in shopping basket per year (columns)
and
- value shopping basket per year (line)
Screenshot 2023-03-05 at 08.43.51.png
So far so good. I now want to combine them so I change the chart type to a combo. When I do this, the column chart drops the 2 highest values...
Screenshot 2023-03-05 at 08.44.20.png
and the lemons and grapes disappear.
Spreadsheet attached. Thoughts on what I am doing wrong? PS have anonymised my original data to fruit for obvious reasons :-)
adding secondary axis ignores data.xlsx
Bookmarks