Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
If the new column is an additional data point to an existing series then you can use named ranges to create a dynamic chart. http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy Mr. Platypus wrote: I am developing a series of charts that will have data added to them on a monthly basis. Specifically, I would like the data source to add one column of data every month. Currently, all I could come up with was highlighting a bunch of empty fields and letting the data catch-up. The problem with that is: it leaves a big blank space in the chart. Any ideas? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto updating source data | Excel Discussion (Misc queries) | |||
auto updating source data | Charts and Charting in Excel | |||
auto data source, removing null | Charts and Charting in Excel | |||
Adding Source Data to a Chart. | Charts and Charting in Excel | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |