Home |
Search |
Today's Posts |
#1
|
|||
|
|||
chart question
i have three columns with numbers and one with a
percentage. I would like to create a graph with stacked colunns for the numbers and a line for the percentage on a different axis. is this possible. i know i can do it with regular columns but i need it with stacked columns. |
#2
|
|||
|
|||
On Wed, 2 Mar 2005 07:21:07 -0800, "frank" wrote:
i have three columns with numbers and one with a percentage. I would like to create a graph with stacked colunns for the numbers and a line for the percentage on a different axis. is this possible. i know i can do it with regular columns but i need it with stacked columns. One way is to include additional rows AND columns for the secondary axis. For example Total Subset Subset % Value 1 8 13 Value 2 86 83 Value 3 6 4 % 1 13% % 2 83% % 3 4% Now you can format the % data series on the secondary axis, then just delete them out of the legend, If you need additional help just write back Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Area Chart Question | Charts and Charting in Excel | |||
Excel chart question | Charts and Charting in Excel | |||
basic pie chart question | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel | |||
Chart question insert | Excel Worksheet Functions |