Need to change the display of a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!

I have several pie charts that I have created to show percentages. In
several of them, there are multiple legend values for the same percentage
(0%). Excel prints all of them stacked on top of each other, with their
leader lines and in some cases it runs into the title of the chart. Is there
any way to change this? Also, in some other cases, with the same situation,
there are no leader lines displayed (even though I told it to under Chart
Options) and the values all print on top of each other. Suffice it to say,
these charts are not very readable. Can anyone help me on this? Is there
any way to change the chart layout (or whatever you call it) to make these
problems go away?

Thanks in advance!
 
To avoid the zeros, you can
(1) hide those rows of data and set the chart options (with the chart
selected, select Tools | Options... | Chart tab) to 'Plot visible cells
only', or
(2) Double-click the datalabels and from the Number tab: on the left
select a Custom format; on the right in the Type: box enter 0%;0%;_
where the underscore is meant to represent a space; so you should
actually use the space bar instead of the underscore.

As far as leader lines go, I believe they exist only in pie charts. If
you are creating some other kind of a chart, they may not be supported.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks so much!


Tushar Mehta said:
To avoid the zeros, you can
(1) hide those rows of data and set the chart options (with the chart
selected, select Tools | Options... | Chart tab) to 'Plot visible cells
only', or
(2) Double-click the datalabels and from the Number tab: on the left
select a Custom format; on the right in the Type: box enter 0%;0%;_
where the underscore is meant to represent a space; so you should
actually use the space bar instead of the underscore.

As far as leader lines go, I believe they exist only in pie charts. If
you are creating some other kind of a chart, they may not be supported.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Click to expand...
 
Back
Top