Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 14th 06, 03:13 PM posted to microsoft.public.excel.charting
TerenYoung
 
Posts: n/a
Default Powerpoint Graph- Shading in between two linear graph lines

If I created a linear graph (in Powerpoint) with two lines: one showing
actual money spent and the other showing the budget over the course of a year
is it possible to shade the difference (or the region of space) between the
two lines. Basically indicated the sizable difference in actual money spent
and budget?

  #2   Report Post  
Old June 15th 06, 09:29 AM posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Powerpoint Graph- Shading in between two linear graph lines

Hi,

Yes you can do this by adding 2 extra data series and plotting them as
Area charts.

Assuming your line data is currently in row 1 and 2 of the datasheet and
your data is plotted By Rows.
Copy row 2 to row 3
Copy row 1 to row 4

Now select the series in row 3 and change the chart type to Area, do not
worry about the change of x axis for the moment.
Format this new area chart to have the required fill colour and no border.
Change the chart type of the series in row 4 to area chart. Change it's
fill colour to that of the plotarea and set the border to none. This
will act as a mask for the lower part of the other area chart.

The above will work if the 2 lines of data do not cross.


This is an example using Excel.
http://www.andypope.info/ngs/ng21.htm

Cheers
Andy


TerenYoung wrote:
If I created a linear graph (in Powerpoint) with two lines: one showing
actual money spent and the other showing the budget over the course of a year
is it possible to shade the difference (or the region of space) between the
two lines. Basically indicated the sizable difference in actual money spent
and budget?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


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
How do i get lines on a line graph? baffledbrewer Charts and Charting in Excel 2 June 4th 06 01:38 PM
How do i get lines on a line graph? baffledbrewer Charts and Charting in Excel 2 June 4th 06 01:31 PM
Line Graph and Shading Jim Charts and Charting in Excel 2 November 18th 05 06:30 PM
copy-paste from excel to powerpoint - grid lines Cowtoon Excel Discussion (Misc queries) 3 October 5th 05 12:41 AM
Copying an Excel Graph to PowerPoint Sandy Charts and Charting in Excel 2 February 7th 05 10:58 PM


All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017