Forum Discussion
Excel - graph problem
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
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
- Dear Sergei,
you're awesome! Thank you so much!!!You are welcome
