Hi,

If the chart data is not highlighted when you select the chart it us
normally because the charts data range is not contiguous.

You could use the Source Data dialog to Add new data series.
If the new columns are an extension to an existing data series then take
a look at using dynamic ranges.

http://peltiertech.com/Excel/Charts/Dynamics.html
http://processtrends.com/pg_dynamic_charts.htm
http://www.xl-logic.com/xl_files/cha...ic_chart_3.zip
http://www.bmsltd.ie/DLCount/DLCount...e=FunChrt1.zip
http://www.xl-logic.com/xl_files/cha...ic_chart_1.zip
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
http://support.microsoft.com/default...b;en-us;147803

Cheers
Andy

P

galatea2153 wrote:
Hi,
I prepare simple graphs each month for work. In the past I have simply
added a new column for new information, and (by clicking on graph and finding
the cells) expanding the graph to cover the new information. However, the
last couple of months when I click on the graph, no cells are highlighed and
I have to re-do the graph from scratch. I am unsure why this has happened,
seemingly for no reason. Can anyone give me any suggestions?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info