Forum Discussion
Excel - graph problem
Hello,
I need your help with axis X. Could you clarify what should I do to keep the scale. At the moment I have seven values and the distance are the same between each of number.
11 Replies
This is because you are using the wrong chart type.
Instead of a "line chart", try with a "X Y (Scatter)" chart with lines connecting the dots. This should fix your issue.
Scatter will give the same result
Dear Sergei, because you are really a master in Excel stuff, could you also advise how could I prepare a common graph for the attached numbers. I need to put it under the main graph in the same scale but something is wrong
It looks like you values for X are formatted as text, aren't they?
Dear, I need exaclty the same graph like this one
For data as this add helper column
Add line chart on first 3 columns
Right click on chart, Select Data, remove first series and change X axis on helper column
Click on X axis to format and select Date axis type.
Select Data and add one more series with Y from first column
Select Data labels and deselect horizontal axis
After that cosmetic, format as desired
Dear Sergei,
thank you for you replay, my document looks like this. Could you let me know where should I put numbers: 0,15/2,15/4,15/4,19/4,23/4,83/5,43 and keep the scale?
I need exactly this graph
