Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Click Boxes for each series in a graph
I have a chart with three series over time. Lets say the range is C2:Z5.
The time is expressed in row 2 and the series data in rows 3,4,5. I want to be able to turn the series on with click boxes. I have the graph set up on a worksheet so that some of the cells of the worksheet are visible. I want to avoid VBA code (for now). So I would like to set up checkboxes on the spreadsheet itself (if possible). I want to be able to click the checkbox for each series. When checkbox is click series is visible when not clicked series not visible. Any ideas on how to do this? Thanks. |
#2
|
|||
|
|||
Click Boxes for each series in a graph
Hi ExcelMonkey,
If you want to do this without VBA, first insert rows betweeen the last two series. i.e. click on the row number 5 to select the whole row and use menu item Insert - Rows, then click on roe number 4 and Insert - Rows. The three series should now be in rows 3, 5, and 7. Select Row 3 and use the menu item Data - Group and Outline - Group this places a small box with a '-' sign next to Row 3. Do the same for Row 5 and 7. Now, clicking on a '-' sign will toggle visibility for the series. Otherwise, use VBA. Ed Ferrero http://edferrero.m6.net/ I have a chart with three series over time. Lets say the range is C2:Z5. The time is expressed in row 2 and the series data in rows 3,4,5. I want to be able to turn the series on with click boxes. I have the graph set up on a worksheet so that some of the cells of the worksheet are visible. I want to avoid VBA code (for now). So I would like to set up checkboxes on the spreadsheet itself (if possible). I want to be able to click the checkbox for each series. When checkbox is click series is visible when not clicked series not visible. Any ideas on how to do this? Thanks. |
#3
|
|||
|
|||
Click Boxes for each series in a graph
Try this example:
http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ExcelMonkey wrote: I have a chart with three series over time. Lets say the range is C2:Z5. The time is expressed in row 2 and the series data in rows 3,4,5. I want to be able to turn the series on with click boxes. I have the graph set up on a worksheet so that some of the cells of the worksheet are visible. I want to avoid VBA code (for now). So I would like to set up checkboxes on the spreadsheet itself (if possible). I want to be able to click the checkbox for each series. When checkbox is click series is visible when not clicked series not visible. Any ideas on how to do this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a second axis to a graph with 2 data series? | Charts and Charting in Excel | |||
how do I change the data series an an excel graph | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
graphing two series on x axis | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |