dynamic end on chart

D

Donna YaWanna

I have to update dozens of charts every day with the previous day's stats.
The new data is always added to the next column on the right. Is there a way
to tell my chart to get all data even though the number of columns changes
every day?

Example:
Yesterday I had data through column AD.
Today I add data for column AE and revise the chart to get that data.
What I've tried doing is telling the chart to get data through column BZ.
This works but then the right side of my column chart is empty because I
don't have data yet. I want the chart full size all the time.
Possible?

Thanks wiz kids.
 

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

How do I create a scrolling line chart? 0
Chart SERIES OFFSET 5
My chart's X-axis isn't working properly 0
Excel 2007 charts: want to avoid zero values 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Dynamic series in rows 1
Remove white area on chart 2
Multiple columns over a chart 0

Top