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.
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