Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
JB12
 
Posts: n/a
Default Changing a line color when it crosses another benchmark line?

I have a chart where the average of the coporation as a whole is used as a
benchmark and then from a drop down list you can select an entity you want to
compare to the benchmark. I am hoping to have the line of the entity change
colors (i.e. from solid black to solid red) if it exceeds the benchmark line.
Is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Changing a line color when it crosses another benchmark line?

Andy Pope has an example like this on his web site:

http://andypope.info/charts/conditionalline.htm

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


"JB12" wrote in message
...
I have a chart where the average of the coporation as a whole is used as a
benchmark and then from a drop down list you can select an entity you want
to
compare to the benchmark. I am hoping to have the line of the entity
change
colors (i.e. from solid black to solid red) if it exceeds the benchmark
line.
Is this possible?



  #3   Report Post  
Posted to microsoft.public.excel.charting
JB12
 
Posts: n/a
Default Changing a line color when it crosses another benchmark line?

Jon,

You always seem to have the right answer. I looked at Andy Pope's
information and I'm not sure that example with work the way I need it to. I
am going to be updating data month and with this update the line could fall
below, stay above, or rise above the average line. Would his scatter plot
example work in that case or would I need to adjust my thinking? If his
example does work - do you have any idea how I would rework my line chart and
information to display the info appropriately. Currently my data is pulled
via an if/then formula. Thanks for all the helpful info

"Jon Peltier" wrote:

Andy Pope has an example like this on his web site:

http://andypope.info/charts/conditionalline.htm

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


"JB12" wrote in message
...
I have a chart where the average of the coporation as a whole is used as a
benchmark and then from a drop down list you can select an entity you want
to
compare to the benchmark. I am hoping to have the line of the entity
change
colors (i.e. from solid black to solid red) if it exceeds the benchmark
line.
Is this possible?




  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Changing a line color when it crosses another benchmark line?

Try Andy's example, then post back with any issues that remain unanswered.

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


"JB12" wrote in message
...
Jon,

You always seem to have the right answer. I looked at Andy Pope's
information and I'm not sure that example with work the way I need it to.
I
am going to be updating data month and with this update the line could
fall
below, stay above, or rise above the average line. Would his scatter plot
example work in that case or would I need to adjust my thinking? If his
example does work - do you have any idea how I would rework my line chart
and
information to display the info appropriately. Currently my data is
pulled
via an if/then formula. Thanks for all the helpful info

"Jon Peltier" wrote:

Andy Pope has an example like this on his web site:

http://andypope.info/charts/conditionalline.htm

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


"JB12" wrote in message
...
I have a chart where the average of the coporation as a whole is used as
a
benchmark and then from a drop down list you can select an entity you
want
to
compare to the benchmark. I am hoping to have the line of the entity
change
colors (i.e. from solid black to solid red) if it exceeds the benchmark
line.
Is this possible?






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
Auto Date 4 changing fields in a line nastech Excel Discussion (Misc queries) 3 October 12th 05 11:49 PM
Changing Line in line chart B Dubinsky Charts and Charting in Excel 1 January 21st 05 05:10 AM


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