% as column not Pie

D

DeltaEcho

Im trying to create a single column chart to express three
values as a percentage of the overall total. It works
using the default pie chart but I cant get it to express
the values in a vertical single column. Thanks for any
tips or help in advance.
 
J

Jon Peltier

In the chart wizard, select the 100% Stacked Column chart type, the top
left option of the Column chart family. If your three values are aligned
horizontally in the sheet, make sure the chart is aligned by columns (or
vice versa).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Pie Chart 4
Pie chart with hatch marks (black and white) 1
Excel 2010 Data Labels options not saving 0
Pie chart break down 0
How to create a chart based on color percentage? 1
pie chart areas reflect magnitude 5
Percentage 3
Pie Chart and Table Query 2

Top