close

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.

peltiertech.com/Excel/Charts/Dynamics.html
www.tushar-mehta.com/excel/ne...rts/index.html
www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

Cheers
Andy

jlarson wrote:
gt; I have several time series charts thta I update for each business day. I
gt; would like the chart data series's to automaticallt expand as I add data.

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()