Blurred Vision

[jack]

Office 2003 Excel worksheet. I have made a "hanging tubes" type of chart to
track monthly expenditures. On some months there might be "$0.00" spent in a
category. On the chart the amount "$0.00" is behind the category name
(because there is no bar to show), looking blurred and of course not neat at
all. Of course when there are expenditures the amont is out at the end of
the bar. Oh, yes I chose to have the amounts show at the end of the bars.
Do I have to delete this option? I have looked for "don't show 0 amounts but
can not find it for this particular function. Thanks so much in advance!
jack

 

[Jim Cone]

Try changing the formulas so they return #N/A if the amount spent is zero.
Charts display that a little different. Worth a look.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"jack" <[email protected]>
wrote in message
Office 2003 Excel worksheet. I have made a "hanging tubes" type of chart to
track monthly expenditures. On some months there might be "$0.00" spent in a
category. On the chart the amount "$0.00" is behind the category name
(because there is no bar to show), looking blurred and of course not neat at
all. Of course when there are expenditures the amont is out at the end of
the bar. Oh, yes I chose to have the amounts show at the end of the bars.
Do I have to delete this option? I have looked for "don't show 0 amounts but
can not find it for this particular function. Thanks so much in advance!
jack

 

[jack]

Thanks, will try as soon as I return to that project and let you know. jack

 

[jack]

Last post showed blank. I'll try again and say THANKS and I'll take your
advice the next time I get to that project. I will let you know. jack