Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
B
 
Posts: n/a
Default Conditional formating in Charts

Does Excel allow you to use conditional formatting in charts?
I have a bar chart that I am locking the y-axis at specific values. I would
like to change the color of any bars that are graphing outside the locked
y-axis.

Thanks
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Jon Peltier has instructions for conditional charts:

http://www.peltiertech.com/Excel/Cha...html#CondChart


B wrote:
Does Excel allow you to use conditional formatting in charts?
I have a bar chart that I am locking the y-axis at specific values. I would
like to change the color of any bars that are graphing outside the locked
y-axis.

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
more than 3 conditional formating in excel Manan Excel Discussion (Misc queries) 2 February 7th 05 09:12 PM
Conditional formating in Excel Charts. REvans Charts and Charting in Excel 4 January 27th 05 11:53 AM
conditional format of data tables in charts [email protected] Charts and Charting in Excel 2 January 25th 05 03:56 PM
Conditional Formating when result is text Lary Excel Worksheet Functions 1 December 16th 04 02:13 AM
30 Day Aging Report Using Conditional Formating Tiegris Excel Worksheet Functions 0 November 4th 04 10:07 PM


All times are GMT +1. The time now is 01:58 PM.

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"