csehz
asked on
Excel 2000 - Chart creation
Dear Experts,
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
thanks,
ChartExample.xls
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
thanks,
ChartExample.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes I know still need to think it through in which format would be more readable, this solutions is okay for me
thanks very much,