I do not have too much experience creating charts, could you please check the attached file, it contains daily percentage of sellings.
Could you please advise how to do a line diagram, which would show
- column A so the Date days on the X axis
- colum C so the Type of cars would be the series
- column G so the Percent should be the values
Somehow the wizard takes different categories automatically, briefly I would just need the 25 days on X, showing the percentages for 9 cars daily