Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Colour shade an area in an Excel graph!


Hello all!

Am Arun and I work for Vtec corp.
Well, a quick qn.

I constructed a line between points (0,3) and (16,3) (above an
parallel to the X Axis). Is there a way I can colour-shade the regio
bounded by the above line and the X-axis? (the X- axis is 16 units lon
and has units marked till (16,0)).

I look forward to your help guys.

Thanks a bunch in advance.

Regds,
Arun

--
aiye
-----------------------------------------------------------------------
aiyer's Profile: http://www.excelforum.com/member.php...nfo&userid=607
View this thread: http://www.excelforum.com/showthread.php?threadid=26404

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Colour shade an area in an Excel graph!

Hi Arun -

Take a look at this web page. I show how to make a combination XY-Area chart:

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

Alternatively, you can use this topic for such a simple shading pattern. Use only
one column series, with only one point, with a value of 3.

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

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

aiyer wrote:

Hello all!

Am Arun and I work for Vtec corp.
Well, a quick qn.

I constructed a line between points (0,3) and (16,3) (above and
parallel to the X Axis). Is there a way I can colour-shade the region
bounded by the above line and the X-axis? (the X- axis is 16 units long
and has units marked till (16,0)).

I look forward to your help guys.

Thanks a bunch in advance.

Regds,
Arun.



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 shade in part of a graph? reid Charts and Charting in Excel 4 May 4th 23 11:42 AM
How do I shade the area between two lines on a chart? Hart Charts and Charting in Excel 4 April 3rd 23 04:29 PM
How can I shade area under a norm dist graph? TimH Charts and Charting in Excel 1 November 16th 07 06:24 AM
How do I shade the area underneath a curve Mari Excel Discussion (Misc queries) 0 September 28th 06 08:55 PM
HOW DO I SHADE AN AREA ON A BELL CURVE? jeanne Charts and Charting in Excel 2 January 30th 05 09:29 PM


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