Search:  

 
theme to white backgroundlet page decide theme
HomeFind ServiceReviewsISP NewsFAQsForumsToolsDatabaseAbout 
 
   All ForumsHot TopicsGallery






how-to block ads


 
Forums » Tech and Talk » OS and Software » Microsoft Help » [Excel] Formula Question
Search Topic:
 Share Topic:
RSS topic:
toggle:
flat / full
normal / watch
Posting:
Post a:
Post a:
Links: ·MS Apps FAQ ·Windows XP FAQ ·Product Catalog ·Windows Home
[Vista] java quit working today »
« [NEW!] Windows Media Player 11 [XP 64-bit]  
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: #;-#;""
to forum · permalink · 2008-10-11 19:59:14 · Reply to this

zach3
Zach
Premium
join:2000-05-04
Saint Louis, MO
clubs:

 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
to forum · permalink · · 2008-10-11 20:52:38 · Reply to this
-
Forums » Tech and Talk » OS and Software » Microsoft Help[Vista] java quit working today »
« [NEW!] Windows Media Player 11 [XP 64-bit]  

Tuesday, 01-Dec 02:54:13 Terms of Use | Privacy Policy | Hosting by www.nac.net - DSL,Hosting & Co-lo | feedback | contact
over 10 years online! © 1999-2009 dslreports.com.
page compression OFF
Most commented news this week
· [57] Baltimore To Ban Lazy Cable Installs
· [47] Broadband Killed The Game Console
· [33] Rural Carriers Quickly Embracing Fiber
· [28] AT&T Top Lobbyist Cicconi Has His Feelings Hurt
· [24] Charter Exits Chapter 11
· [21] Midcontinent Socked With Easement Lawsuit
· [3] Monday Morning Links
· [2] Monday Evening Links
Most people now reading
· Is Microsoft Technet ok to use for my family PC's? [Microsoft Help]
· Connecting to Google Voice Via SIP [VOIP Tech Chat]
· Windows 7 boot manager editing questions [Microsoft Help]
· Considering Leaving Vonage, who should I Consider? [VOIP Tech Chat]
· Why is VoIP Better than POTS? [VOIP Tech Chat]
· persistent connection to qw-in-f113.1e100.net on boot [Security]
· [Snow Leopard] NFS Mounts - no more Directory Utility [All Things Macintosh]
· [Rant] called out sick! [Rants, Raves, and Praise]
· 3.x Feral Druid - Bear Tanking Guide [World of Warcraft]
· Opening a file download dialog from a JavaScript function. [Webmasters and Developers]