republican-creole
site Search:


 
    All Forums Hot Topics Gallery






how-to block ads


 
Search Topic:
Share Topic
Posting?
Post a:
Post a:
Links: ·MS Apps FAQ ·Windows XP FAQ ·Windows 7 FAQ ·Windows Home ·Office Home
AuthorAll Replies


xlhth

@optonline.net

reply to zach3

Re: [Excel] Formula Question

Try,

worksheet cell formula =IF(A1>0,A1,0)

In the chart
Click the data series
Format>Selected Data Labels
Category>Custom
Type: #;-#;""

zach3
Zach
Premium
join:2000-05-04
Saint Louis, MO
Reviews:
·AT&T Yahoo
·AT&T Southwest

xlhth,

Thanks, that seems to solve the problem of the expanding chart just fine!!

I am using Office 2003 and I can't seem to find the The data series in the format you are asking me to try. I can find Format>Data Labels but not the term "Selected". I can find Category name but not "Custom"

The problem is solved except that I end up with zeros showing in the chart and I would prefer that they didn't show.

One step at a time!

Zach


Wednesday, 30-May 08:03:46 Terms of Use & Privacy | feedback | contact | Hosting by nac.net - DSL,Hosting & Co-lo
over 12.5 years online © 1999-2012 dslreports.com.
Most commented news this week
Hot Topics