Excel graph problems

[Pieter Doutreligne]

Hello

My excel skills aren't exaclty up to par, so I'm having some difficulties.

I need to insert data into an excel worksheet. That data would then be
inserted into an excel graph. But because I'll be inserting new data into
the worksheet every day, I'll need to find a way to automatically update the
graph with the new data inserted. This way I don't have to do it manually
every time I add something.

Could someone help me out?

Thanks in advance,

-Pieter Doutreligne

 

[Earl Kiosterud]

Pieter,

If you'll be adding data, like additional rows, and need the chart to
accomodate them, you must either include those cells in the initial design
of the chart, which will leave data points of zero until the data arrives,
or use the dynamic range technique to cause more data points to appear in
the chart as you add data to the sheet. Searching:
"dynamic range" Excel
yielded:
http://www.contextures.com/xlNames01.html

Once the dynamic range is created, use it in the chart. You may need to
create at least two dynamic ranges, one for the chart labels (categories),
and another for the data values. Searching:
"dynamic range" excel chart
yielded:
http://www.beyondtechnology.com/geeks021.shtml

Earl Kiosterud
mvpearl omitthisword at verizon period net