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 Snuffles00 on May 29, 2020
by ShereenLavi on May 29, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020
Posted in Microsoft Ignite The Tour 2019 on February 14, 2020