Chart with VB programming?

[Sri]

Hello,

I have a stacked chart with 4 different types of metrics on the Y axis and
the timeline on X axis. I simplified this by breaking this up into 4
different charts.

Alternately, I would like to have a single graph where the timeline remains
unchanged. I then would have 2 dropdown boxes, the first one should help in
choosing which metric I would like to show and the second dropdown should
help if I would like to show the metric in actual numbers or as a percentage.

Is there way I can achieve this? Any help is greatly appreciated.

Sri.

 

[Shane Devenshire]

Hi,

The answer is this can be done but will probably require VBA.

Check out Jon's site, I think he does something with this:

http://www.google.com/custom?hl=en&...q=controlling+charts+with+combo+boxes&spell=1

I wrote a chapter in an Excel book on this but it's probably out of print.

 

[Jon Peltier]

You can make panel charts to show all series:

How to Build a Simple Panel Chart -
http://peltiertech.com/WordPress/how-to-build-a-simple-panel-chart/
Stacked Charts With Vertical Separation -
http://peltiertech.com/Excel/Charts/StackedCharts.html
Panel Charts with Different Scales -
http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

Or a dynamic, interactive chart to selectively show one series by itself or
with the others grayed out:

Easier Interactive Multiple Line Chart -
http://peltiertech.com/WordPress/easier-interactive-multiple-line-chart/
Interactive Charts with Checkboxes and Formulas -
http://peltiertech.com/WordPress/interactive-charts-with-checkboxes-and-formulas/
Interactive Charts with Checkboxes and VBA -
http://peltiertech.com/WordPress/interactive-charts-with-checkboxes-and-vba/
Display One Chart Dynamically and Interactively -
http://peltiertech.com/WordPress/display-one-chart-dynamically-and-interactively/


Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html

- Jon