Jan 10 2019 06:18 AM
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.
Jan 10 2019 06:31 AM
It looks like you values for X are formatted as text, aren't they?
Jan 10 2019 06:43 AM
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?
Jan 10 2019 08:08 AM
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
Jan 10 2019 08:11 AM
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.
Jan 10 2019 10:40 AM
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
Jan 10 2019 03:31 PM
To show stacked bar in cumulative scale add one more helper column (E) where the values are difference between related cell in column A and previous to it. Select that helper column and build stacked bar chart on it.
To add the as labels the values from column A you may from labels format pane (values from cell option) or simply select label box and in formula bar add reference on right cell