Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
satraver
 
Posts: n/a
Default formatting text on chart for specific values

Please help! I have a list of dates on X axis and # of downtime minutes for
those dates on the Y axis. I'd like to show all of the dates that have
downtime=0 as blue text, but I can't figure out how to make only those with a
y value of 0 show up as blue on my chart. Any suggestions? Thanks in
advance!
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default formatting text on chart for specific values

Hi,

This page may help with the formatting of axis labels.
http://www.andypope.info/charts/hiliteaxislabels.htm

Cheers
Andy

satraver wrote:
Please help! I have a list of dates on X axis and # of downtime minutes for
those dates on the Y axis. I'd like to show all of the dates that have
downtime=0 as blue text, but I can't figure out how to make only those with a
y value of 0 show up as blue on my chart. Any suggestions? Thanks in
advance!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing text and returning boolean values nicoleeee Excel Discussion (Misc queries) 9 December 2nd 05 10:43 AM
Chart title text linked from a cell? Possible? cwinters Excel Discussion (Misc queries) 2 October 10th 05 09:28 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
How to omit data in a chart when there are error values? Bou Charts and Charting in Excel 2 June 10th 05 08:51 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"