LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default turning lines on/off on a set of charts

I have a set of columns and each contains a list of parameters that
describe a scenario. (Not any Excel-specific meaning of "scenario" (I
think there is such a thing), but just the ordinary meaning of "it
could be like this, or like this, or this...." parameter lists).

I may input the descriptions of ten different scenarios, and then I
have a set of charts for viewing the various implications of the
scenarios. Having ten lines on a single chart is way too confusing.
I'm usually interested in contrasting just two or three of them at a
time. If this were an ordinary app, I'd have a checkbox above each
column of parameters that would stand for "include in charts? yes or
no?".

I'm not quite sure how to do such a thing with Excel. I'm a programmer
(C++, C#, Lisp, etc.), but I'm a novice at Excel, so the simpler the
solution, the better. I realize that I can get the macro recorder to
write some useful code for me, and then I can try to tweak the code,
but I'm not even sure what I would do manually that I could record to
get code for adding and removing series from a set of charts (not just
one) in response to a "yes" or "no" in a cell.

I'd be grateful for any suggestions.

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
Line Charts have no lines Chad Cameron[_2_] Charts and Charting in Excel 1 March 11th 10 10:50 PM
charts - 1 column and 2 lines Katleen Charts and Charting in Excel 1 September 3rd 07 09:34 AM
Smooth lines for 3-D pie charts? RussG Charts and Charting in Excel 0 February 8th 06 02:48 PM
lines on bar charts DavidNHFCU Charts and Charting in Excel 4 May 9th 05 03:02 PM
Charts with many lines Jen Kulak Excel Discussion (Misc queries) 2 May 6th 05 07:48 PM


All times are GMT +1. The time now is 07:33 AM.

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"