01-10-2019 06:18 AM
01-10-2019 06:43 AM
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?
01-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
01-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.
01-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
01-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
by JyrkiT on April 16, 2020