Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill an area between 2 curves in an Excell chart?
I created an excell x-y chart that has 4 curves on it. Is it possible to
select 2 of the curves and shade the area between them? |
#2
|
|||
|
|||
You can do it with an area chart, or by adapting this VBA technique:
http://peltiertech.com/Excel/Charts/VBAdraw.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ syseng wrote: I created an excell x-y chart that has 4 curves on it. Is it possible to select 2 of the curves and shade the area between them? |
#3
|
|||
|
|||
Hi Jon
I used your technique and it worked but how do I clear the shapes if I want to plot something else. I know this can be done by selecting the shapes then delete but is there a way to write VBA to clear them with a click of a button?? thanks "Jon Peltier" wrote: You can do it with an area chart, or by adapting this VBA technique: http://peltiertech.com/Excel/Charts/VBAdraw.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ syseng wrote: I created an excell x-y chart that has 4 curves on it. Is it possible to select 2 of the curves and shade the area between them? |
#4
|
|||
|
|||
Hi,
2 ways, activechart.Shapes.SelectAll selection.delete do while activechart.Shapes.Count 0 activechart.Shapes(activechart.Shapes.Count).Delet e loop Cheers Andy Ali Baba wrote: Hi Jon I used your technique and it worked but how do I clear the shapes if I want to plot something else. I know this can be done by selecting the shapes then delete but is there a way to write VBA to clear them with a click of a button?? thanks "Jon Peltier" wrote: You can do it with an area chart, or by adapting this VBA technique: http://peltiertech.com/Excel/Charts/VBAdraw.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ syseng wrote: I created an excell x-y chart that has 4 curves on it. Is it possible to select 2 of the curves and shade the area between them? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Thank you Andy
"Andy Pope" wrote: Hi, 2 ways, activechart.Shapes.SelectAll selection.delete do while activechart.Shapes.Count 0 activechart.Shapes(activechart.Shapes.Count).Delet e loop Cheers Andy Ali Baba wrote: Hi Jon I used your technique and it worked but how do I clear the shapes if I want to plot something else. I know this can be done by selecting the shapes then delete but is there a way to write VBA to clear them with a click of a button?? thanks "Jon Peltier" wrote: You can do it with an area chart, or by adapting this VBA technique: http://peltiertech.com/Excel/Charts/VBAdraw.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ syseng wrote: I created an excell x-y chart that has 4 curves on it. Is it possible to select 2 of the curves and shade the area between them? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
|
|||
|
|||
Thanks Jon,
I will give this a try. syseng "Jon Peltier" wrote: You can do it with an area chart, or by adapting this VBA technique: http://peltiertech.com/Excel/Charts/VBAdraw.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ syseng wrote: I created an excell x-y chart that has 4 curves on it. Is it possible to select 2 of the curves and shade the area between them? |
#7
|
|||
|
|||
Thanks Jon!
syseng "Jon Peltier" wrote: You can do it with an area chart, or by adapting this VBA technique: http://peltiertech.com/Excel/Charts/VBAdraw.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ syseng wrote: I created an excell x-y chart that has 4 curves on it. Is it possible to select 2 of the curves and shade the area between them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Fill area beneath a scatter plot | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |