republican-creole
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

zach3
Zach
Premium
join:2000-05-04
Saint Louis, MO
clubs:		reply to chipshot
Re: [Excel] Formula Question

Chipshot,

Yes, I am wanting the bars to be different colors that I why I choose this method to make the chart. You are very correct it is an involved process because in my final chart format the chart is dynamic.

Thanks,

Zach
to forum · permalink · · 2008-10-11 20:55:00 · Reply to this


xlhth

@optonline.net

 oops

In the chart
Click on one of the values (4170)to highlight the data series labels
Menu Bar > Format > Selected Data Labels
Number Tab > Category > select Custom
enter in Type: #;-#;""

This formats the chart label not to display zero values

For more info, see "Create or delete a custom number format" in Help
to forum · permalink · 2008-10-11 21:55:10 · Reply to this

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

Works like a champ!!

Thanks,

Zach
to forum · permalink · · 2008-10-11 22:12:12 · 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]  

Wednesday, 09-Dec 20:30:05 Terms of Use | Privacy Policy | Hosting by www.nac.net - DSL,Hosting & Co-lo | feedback | contact
over 10 years online! © 1999-2009 dslreports.com.republican-creole
page compression OFF
Most commented news this week
· [198] Sprint Sued For Distracted Driving Death
· [106] AT&T Launching New 24 Mbps U-Verse Tier
· [82] 3G Network Test Says AT&T Is Tops
· [72] Mediacom Unveils 105 Mbps Pricing
· [66] Sprint Poised For A Turnaround?
· [63] WPA Cracker: Test WPA-PSK Networks In 20 Minutes
· [56] AT&T Hints At Usage-Based iPhone Data Pricing
· [51] The Future Of Wi-Fi Is Bright
· [47] Site Leaks Yahoo, Verizon Fed Data Share Pricing
· [44] Microwaving Your Innards Is Not 'Extreme'
Most people now reading
· Is sleeping similar to being dead? [General Questions]
· ICC Strats??? [World of Warcraft]
· ICC strats [World of Warcraft]
· Adobe Flash Player version 10.0.42.34 [Security]
· whole house ups [Home Repair & Improvement]
· Comcast refused to install 400' feet. [Comcast HSI]
· Gift Cards on eBay [General Questions]
· Cross Server Dungeon Experience [World of Warcraft]