Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Robert Hargreaves
 
Posts: n/a
Default Gradient of line chart

Hi everyone I have an interesting one..

I have been wondering for a while if it is possible to have a trigger or a
message if a chart is created or updated to show a line chart with a line
taking a certin gradient indicating an increase which must be monitored.

Thanks for your help.

Rob



  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

You are probably better off using the worksheet for this.

A straight line needs only two points. Suppose the x values are in A
and the Y values in B starting with A2. Then, the formula
=IF((B3-B2)/(A3-A2)C1,"Watch it!","Normal")
gives you what you want. The threshold for the slope is in C1.

You add a conditional format to the cell containing this formula so
that the 'Watch it' is in red and the 'Normal' in green.

You could also add a textbox in the chart and link it to this cell.
That way the state is also in the chart. To do so, click the chart,
enter the equal key then click on the cell containing the formula.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi everyone I have an interesting one..

I have been wondering for a while if it is possible to have a trigger or a
message if a chart is created or updated to show a line chart with a line
taking a certin gradient indicating an increase which must be monitored.

Thanks for your help.

Rob




  #3   Report Post  
Robert Hargreaves
 
Posts: n/a
Default

Thanks Tushar I will try it. Do you know many "pattern spotters" or
"highlighters" similar to this?

I dont really want to have to use add ins.

Thanks
Rob


"Tushar Mehta" wrote in message
om...
You are probably better off using the worksheet for this.

A straight line needs only two points. Suppose the x values are in A
and the Y values in B starting with A2. Then, the formula
=IF((B3-B2)/(A3-A2)C1,"Watch it!","Normal")
gives you what you want. The threshold for the slope is in C1.

You add a conditional format to the cell containing this formula so
that the 'Watch it' is in red and the 'Normal' in green.

You could also add a textbox in the chart and link it to this cell.
That way the state is also in the chart. To do so, click the chart,
enter the equal key then click on the cell containing the formula.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi everyone I have an interesting one..

I have been wondering for a while if it is possible to have a trigger or
a
message if a chart is created or updated to show a line chart with a line
taking a certin gradient indicating an increase which must be monitored.

Thanks for your help.

Rob








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
Line chart in Excel - trendline incomplete [email protected] Charts and Charting in Excel 7 May 13th 05 01:21 PM
Formatting lines between data points in a line chart ltanner Charts and Charting in Excel 2 March 13th 05 06:12 AM
Plotting moving average line on a chart Herbert Chan Charts and Charting in Excel 1 February 26th 05 09:31 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 09:48 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


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