| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fill Options for XY Graphs
Hello,
I want to be able to fill the area under an xy graph. How can I do this? |
|
#2
|
|||
|
|||
|
Hi,
The usual work around is to use another data set plotted as an area chart. This example actual shades between lines but you should get the idea. http://www.andypope.info/ngs/ng21.htm Or have a look at Jon's article if the xy graph is not a simple line. http://peltiertech.com/Excel/Charts/VBAdraw.html Cheers Andy Paul wrote: Hello, I want to be able to fill the area under an xy graph. How can I do this? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
| How do I get rid of the box showing 'fill down' options after I f. | Excel Discussion (Misc queries) | |||
| Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
| what is keyboard shortcuts for auto fill options | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
Linear Mode
