Custom cone chart

V

Vivien Kent

Why does only the bottom row of cones in the custom cone chart appear as 3-D?
All the other rows of data appear as 2-D circles. Is there any way to fix
this?
 
J

Jon Peltier

Vivien -

You mean they are simply flat circles on the floor of the chart? That
means you're charting values that are zero or close to zero. Select the
chart, choose Source Data from the Chart Menu, and select the Series
tab. Click on one of the series which shows only circles, then click in
the Values box. The range with these values should be highlighted with
the marching ants border. Are these values zero?

- 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

Filtered view of Visio Chart 0
Move Chart with Text 0
Save a custom chart as a template 0
In using the cones charts, what is the logic behind the cones tha. 2
Chart SERIES OFFSET 5
Adjust scale of chart to match real world 3
Split form 0
Possible to Combine reports to's to a single box? 0

Top