View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Changing Series for a chart

How is the data arranges? What kind of chart is it and how do you want it to
reflect what the combo shows? This tutorial might have something you can
use:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"drew1987" wrote in message
...
I am making my own budget spreadsheet and have a ComboBox with all 12
months
and a chart showing the Income, Expense, and Balance of a given month.

My problem is I can't code VB to automatically change the series values
for
the chart. Any suggestions?