#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 270
Default Chart Formatting

Is it possible to have a series data point (2) change colour if the value
drops below that of data point (1) and revert back again if it rises above
that of data point (1). (And possibly be a third colour if it is equal in
value)?
Sandy


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Chart Formatting

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sandy" wrote in message
...
Is it possible to have a series data point (2) change colour if the value
drops below that of data point (1) and revert back again if it rises above
that of data point (1). (And possibly be a third colour if it is equal in
value)?
Sandy



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
Chart Formatting Sandy Charts and Charting in Excel 3 August 9th 07 10:14 PM
Need help formatting chart SpEdFriend Charts and Charting in Excel 5 February 4th 07 08:31 PM
chart formatting Zahilly Excel Discussion (Misc queries) 0 June 19th 06 07:34 PM
Pivot Table border formatting and pivot chart formatting [email protected] Excel Discussion (Misc queries) 0 July 22nd 05 02:22 PM
Chart formatting Christianovitch Charts and Charting in Excel 1 January 19th 05 10:55 PM


All times are GMT +1. The time now is 10:26 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"