how to create dynamic charts horizontally?

Hi,


I have month wise data to compute in and out of particular product. I have written macros to calculate. In and out values are in different sheets.
Now i want to create a dynamic bat chart to plot it automatically. not sure how to povide the range as row values vary depend on input

Please let me know how to do this

Data:
In
Jan FEb Mar
10 20 30

Out:
Jan FEb Mar
5 10 15

Will a 'Table' work for you? Just add a new month and the INs/OUTs & the chart follows...

Thanks. this is fine..but where is the code? Can I use column chart instead of bar chart

No code. Are you familiar with 'Tables'? You can pull your source data into the table with formulas and it will automatically update the chart.


Yes, you can change to a column chart, just activate the chart, right click just inside the chart border, select 'Change Chart Type' and select the first column chart (top left) in the series.

thanks for reply. Im not clear on tables. can you pls let me know how to create dynamic charts

Here's some info on how to create a table.

http://office.microsoft.com/en-us/ex...010013764.aspx

Once you have the table set up, create a chart referencing the Table's data. Any changes (adds/deletes,etc.) in the Table's data will be reflected 'dynamically' in the chart.