#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Line Graph - Help

Hi,

I have a line chart for month on month data

Jan'07 Feb'07 Mar'07 Apr'07 May'07 Jun'08
A 93 99 120 111 85 90

This is the Eg data. Is there a way to show difference in values.
For Eg : Jan - Feb there is a +6 difference. Then there is a +11
difference... etc
Is there a way i can show this difference on the graph automatically? Other
than manually inserting a text box??

Thanks
Rajula



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 618
Default Line Graph - Help

I would suggest that you add a second series calculating the differences.
If need be you can plot that on a secondary axis.
--
David Biddulph

"Rajula" wrote in message
...
Hi,

I have a line chart for month on month data

Jan'07 Feb'07 Mar'07 Apr'07 May'07 Jun'08
A 93 99 120 111 85 90

This is the Eg data. Is there a way to show difference in values.
For Eg : Jan - Feb there is a +6 difference. Then there is a +11
difference... etc
Is there a way i can show this difference on the graph automatically?
Other
than manually inserting a text box??

Thanks
Rajula





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
Combination Line and Bar Graph M Moore Charts and Charting in Excel 1 September 1st 06 09:13 AM
How do I set a goal line in a bar graph? mtwelsh72 Charts and Charting in Excel 3 April 14th 06 05:55 PM
Line graph for cumulative number over time Jane Charts and Charting in Excel 0 April 9th 06 07:19 AM
Line Graph Help mickeymouse Charts and Charting in Excel 2 January 27th 06 08:39 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


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