Re: Custom cone chart

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jon Peltier (DOjonNOTxlmvp_at_SPAMpeltiertechME.com)
Date: 08/20/04


Date: Fri, 20 Aug 2004 13:32:22 -0400

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/
_______

Vivien Kent wrote:

> 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?



Relevant Pages

  • Re: dynamic charts
    ... You could set up an AutoFilter, and hide any rows that have a zero or blank in the first column. ... Peltier Technical Services ... I'd like the chart to only show the series whose valuesare greater than zero. ... If it helps - I don't need to resize anything in the chart other than the number of series. ...
    (microsoft.public.excel.charting)
  • Re: dynamic charts
    ... You could have the Worksheet_Calculate event reset the filter, or put a button on the sheet. ... Peltier Technical Services ... After I change some source data, the zeros become numbers in an additional column within the range of the chart source range. ... But the row which was added does not automatically unhide since its not zero. ...
    (microsoft.public.excel.charting)
  • Re: Problem with Charting Null Values
    ... Tutorials and Custom Solutions ... Peltier Technical Services, Inc. - http://PeltierTech.com ... When the dataset values were NULL (not ZERO) the line ... Recently I made some minor changes in the chart size and position on ...
    (microsoft.public.excel.charting)
  • Re: Problem with Charting Null Values
    ... Tutorials and Custom Solutions ... Peltier Technical Services, Inc. - http://PeltierTech.com ... When the dataset values were NULL (not ZERO) the line ... Recently I made some minor changes in the chart size and position on ...
    (microsoft.public.excel.charting)
  • Re: Problem with Charting Null Values
    ... seems that posting a tiny url is a great help, ... Peltier Technical Services, Inc. - http://PeltierTech.com ... When the dataset values were NULL (not ZERO) the line ... Recently I made some minor changes in the chart size and position on the ...
    (microsoft.public.excel.charting)