Charts using List Feature

D

DS

I use charts to sales by month in Excel 2003. Names are displayed in column
A and Months in Row 1. I love the List Feature and how it adds new records
(names/rows) to my chart automatically. However, I was wondering if it will
do the same for columns (months) as they dont add automatically, I always
seem to need to adjust my data range manually.
Thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Pie Chart and Table Query 2
Automatically shift chart data range: redux 6
Excel 2003: problem with "Name Bar" in Excel charts 0
Excel 2007 graphs/charts automatically populate with new data 1
Excel 2007 charts: want to avoid zero values 1
Summarize the monthly recrods by name 3
Assigning a value to one cell based on the date in another... And then doing it again 0

Top