January February March
Type 1 4 6 1
Type 2 5 4 1
Type 3 9 3 2
Type 4 4 2 1
Total 22 15 5
Cumulated22 37 42
I inserted a chart with this data in Microsoft excel 2003 a while ago. I could insert a secondary axis for cumulated line and changed the type of display for line cumulated, which was a column at the first, then changed to a line. But I am not able to do the same in Microsoft excel 2007.
The line cumulated shows the Type 1 , 2 , 3 and 4 as cumulated. I can't select the whole cumulated column to convert it to a line. If I do so, one type can be selected and I can only change that type to a line. What I want is to change the whole cumulated column to a line.
If you need more explanation, I need to send you the chart.
Regards,
Guity
Type 1 4 6 1
Type 2 5 4 1
Type 3 9 3 2
Type 4 4 2 1
Total 22 15 5
Cumulated22 37 42
I inserted a chart with this data in Microsoft excel 2003 a while ago. I could insert a secondary axis for cumulated line and changed the type of display for line cumulated, which was a column at the first, then changed to a line. But I am not able to do the same in Microsoft excel 2007.
The line cumulated shows the Type 1 , 2 , 3 and 4 as cumulated. I can't select the whole cumulated column to convert it to a line. If I do so, one type can be selected and I can only change that type to a line. What I want is to change the whole cumulated column to a line.
If you need more explanation, I need to send you the chart.
Regards,
Guity