Part of a whole Column Chart

G

Guest

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
 
G

Guest

I figured it out- Use Cluster chart and reduce the overlap to zero.
thanks though!
 
B

Bernard Liengme

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reverse Bar Chart 1
Stacked Line Chart 3
Format Column Chart Shading 2
Cumulative Data Labels on Stacked Bar/Column Chart 1
Total of Stacked Column Chart 1
Can Excel produce a clustered and stacked column chart? 2
stacked column chart 4
How can I combine a stacked column chart and line chart? 1

Top