I have a chart that I want to upgrade so that the column data is broken down into 3 colors.
My orginal chart is pic1. Pic 2 is what I want the column to look like but need to figure out how to add the line section.
Anyone done this before?
I have a chart that I want to upgrade so that the column data is broken down into 3 colors.
My orginal chart is pic1. Pic 2 is what I want the column to look like but need to figure out how to add the line section.
Anyone done this before?
Hi surfengine
This is a solution.
1 - Create a simple stacked column chart with the 4 series (the 3 you want as stacked + the one you want as line)
2 - Right-click on one column on top of the part of the series that you want to be displayed as line and choose Chart Type as Line.
This gives you the chart with 3 series as stacked column and 1 series as Line.
However, it may happen that the Y-scale is not convenient to the line, like in your first example, where the line is percentage and the column is value.
If that's the case,
- right-click on the line and choose Format Data Series>Axis>Secondary Axis
This way you read the line values in a different axis that you can scale as you see fit.
HTH
lecxe
Last edited by lecxe; 10-24-2007 at 01:12 AM.
lecxe,
You rock!!
I cannot believe how simple that was.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks