I have several time series charts thta I update for each business day. I
would like the chart data series's to automaticallt expand as I add data.
I have several time series charts thta I update for each business day. I
would like the chart data series's to automaticallt expand as I add data.
Hi,
You need to read up on dynamic named ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
Cheers
Andy
jlarson wrote:
> I have several time series charts thta I update for each business day. I
> would like the chart data series's to automaticallt expand as I add data.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks