ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Charts using List Feature (https://www.excelbanter.com/excel-discussion-misc-queries/230580-charts-using-list-feature.html)

DS

Charts using List Feature
 
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!!


Jon Peltier

Charts using List Feature
 
Nope, rows only.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

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


"DS" wrote in message
...
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!!





All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com