Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AgileDarrell
 
Posts: n/a
Default Gridlines on Area/Stacked Area charts

I'm trying to see the gridlines on an Stacked Area chart. I understand that
transparency isn't supported, though visible and greyed out. Is there
another way to have above a series be red and below be green and show the
vertical and horizontal gridlines?

TIA
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Add gridlines using this technique:

http://peltiertech.com/Excel/Charts/...Gridlines.html

Since these gridlines are really error bars, they are drawn in front of
area chart series.

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


AgileDarrell wrote:

I'm trying to see the gridlines on an Stacked Area chart. I understand that
transparency isn't supported, though visible and greyed out. Is there
another way to have above a series be red and below be green and show the
vertical and horizontal gridlines?

TIA

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
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM
More options for Area charts - suggestion to MS Jerry W. Lewis Charts and Charting in Excel 0 May 5th 05 04:26 PM
Can Excel calculate area for 3-D surface charts? RAH Charts and Charting in Excel 2 March 20th 05 03:20 AM
Bar Chart Label Sizes [email protected] Charts and Charting in Excel 2 December 27th 04 03:19 PM
How do I show gridlines over a chart area? Chris M Peterborough UK Charts and Charting in Excel 1 December 9th 04 01:06 AM


All times are GMT +1. The time now is 12:41 PM.

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

About Us

"It's about Microsoft Excel"