LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ExcelMonkey
 
Posts: n/a
Default 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.

 
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 add a second axis to a graph with 2 data series? Laura Charts and Charting in Excel 2 February 2nd 05 03:30 PM
how do I change the data series an an excel graph Deb Charts and Charting in Excel 1 February 1st 05 03:05 AM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM
graphing two series on x axis Ladislav Ligart Charts and Charting in Excel 2 December 6th 04 06:50 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


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