| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I create layers in a graph
I am looking to try to create layers so that I can display a graph and add on
transparancies to show comparison between graphs. So in effect, I will have 6 graph transparancies, I would like to be able to display all graphs at the same time overlayed and be able to see how they compare to each other, then I would like to be able to add or remove a graph as need be. Thanks Lawrence |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how can I create layers in a graph
Hi Lawrence,
Why not link each seires to a checkbox, and use each checkbox to turn each series on or off? That way you only have a single chart, can display as few or as many series as you like, and don't have to worry about alignment of different charts. Dave "Lawrence" wrote: I am looking to try to create layers so that I can display a graph and add on transparancies to show comparison between graphs. So in effect, I will have 6 graph transparancies, I would like to be able to display all graphs at the same time overlayed and be able to see how they compare to each other, then I would like to be able to add or remove a graph as need be. Thanks Lawrence |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how can I create layers in a graph
See the Checkbox example he
http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Dave Curtis" wrote in message ... Hi Lawrence, Why not link each seires to a checkbox, and use each checkbox to turn each series on or off? That way you only have a single chart, can display as few or as many series as you like, and don't have to worry about alignment of different charts. Dave "Lawrence" wrote: I am looking to try to create layers so that I can display a graph and add on transparancies to show comparison between graphs. So in effect, I will have 6 graph transparancies, I would like to be able to display all graphs at the same time overlayed and be able to see how they compare to each other, then I would like to be able to add or remove a graph as need be. Thanks Lawrence |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Breakdown the cell into multiple layers | Excel Discussion (Misc queries) | |||
| Conditional Formatting should not be limited to 3 layers. | Excel Discussion (Misc queries) | |||
| Microsoft Excel should allow layers that can be turned on and off. | Excel Worksheet Functions | |||
| Combine excel sheets in layers | Excel Discussion (Misc queries) | |||
| 2 or more layers on a Gantt Chart(Excel 2002) | Charts and Charting in Excel | |||
Linear Mode
