Chart with VB programming?

  • Thread starter Thread starter Sri
  • Start date Start date
S

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.
 
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
 
Back
Top