A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2007 format High Low plot area



 
 
Thread Tools Display Modes
  #1  
Old April 2nd, 2010, 04:03 PM posted to microsoft.public.excel.charting
RNegus
external usenet poster
 
Posts: 13
Default Excel 2007 format High Low plot area

User wants to shade plot area instead of show "high low lines" in a Line
Chart. Any suggestions?
  #2  
Old April 2nd, 2010, 04:24 PM posted to microsoft.public.excel.charting
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Excel 2007 format High Low plot area

EXCEL 2007

To shade the Plot Area:-

1. Click in the Chart to highlight it / ChartTools becomes visible on the
right hand side of the Title Bar / click in the Format contextual tab (just
beneath ChartTools) / in the Current Selection group select Plot Area in the
only drop down list in that group / now click on the Format Selection buttton
(still in the Current Selection group) / Format Chart Area pop up window
should launch with Fill highlighted on orange on the left hand side / choose
the colour that you want from the Color: drop down arrow / Close.

Your Plot Area will now be coloured as you wish.

2. With ChartTools still in place on the right hand side of the Title Bar /
click on the Layout tab / Analysis group / Lines / High-Low Lines can be
toggled on or off here.

If my comments have helped please hit Yes.





"RNegus" wrote:

User wants to shade plot area instead of show "high low lines" in a Line
Chart. Any suggestions?

  #3  
Old April 5th, 2010, 03:45 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Excel 2007 format High Low plot area

If you want to shade the region defined by the high and low, use area
chart type series. The first should plot the low value, the second
should plot the (high minus low). Format the low series so it has no
fill, and the (high minus low) series so it has the fill color you want.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/2/2010 11:03 AM, RNegus wrote:
User wants to shade plot area instead of show "high low lines" in a Line
Chart. Any suggestions?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.