| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Part of a whole Column Chart
How would you make a column chart that shows part of a whole. I want it to
be a stacked chart with just one column the tallest being the whole the shorter being the part. I know this can be done by manipulating the data. But is that the only way? Example: Part 10 Whole 38 Would like -Bar goes to 38 and has 10 shaded. now- bar goes to 48 and has 10 shaded You can change the data Part 10 Other 28 Whole 38 Using just the first two I get what I want. I just figure there is a way to do the other so the vaues on the chart, when you do a mouse over, actually represent what I want. Thanks, Nikki -- Thanks, Nikki |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Part of a whole Column Chart
I figured it out- Use Cluster chart and reduce the overlap to zero.
thanks though! -- Thanks, Nikki "Nikki" wrote: How would you make a column chart that shows part of a whole. I want it to be a stacked chart with just one column the tallest being the whole the shorter being the part. I know this can be done by manipulating the data. But is that the only way? Example: Part 10 Whole 38 Would like -Bar goes to 38 and has 10 shaded. now- bar goes to 48 and has 10 shaded You can change the data Part 10 Other 28 Whole 38 Using just the first two I get what I want. I just figure there is a way to do the other so the vaues on the chart, when you do a mouse over, actually represent what I want. Thanks, Nikki -- Thanks, Nikki |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Part of a whole Column Chart
With 38 in A1 and 10 in A2
In B1 enter =A1-A2 and in B2 enter =B2 Now make the cart from C1:B2 any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Nikki" wrote in message ... How would you make a column chart that shows part of a whole. I want it to be a stacked chart with just one column the tallest being the whole the shorter being the part. I know this can be done by manipulating the data. But is that the only way? Example: Part 10 Whole 38 Would like -Bar goes to 38 and has 10 shaded. now- bar goes to 48 and has 10 shaded You can change the data Part 10 Other 28 Whole 38 Using just the first two I get what I want. I just figure there is a way to do the other so the vaues on the chart, when you do a mouse over, actually represent what I want. Thanks, Nikki -- Thanks, Nikki |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Combine a Floating Column Chart with Line? | Charts and Charting in Excel | |||
| how can I limit my chart | Charts and Charting in Excel | |||
| Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
| Column Chart | Charts and Charting in Excel | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
