Having to re-do graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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/charts/dynamic_chart_3.zip
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FunChrt1.zip
http://www.xl-logic.com/xl_files/charts/dynamic_chart_1.zip
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;147803

Cheers
Andy

P
 
galatea2153 said:
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?
Click to expand...
To add to Andy's list for 'Dynamic Charts' you will find several examples at
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks very much - I'll give it a shot!

Andy Pope said:
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/charts/dynamic_chart_3.zip
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FunChrt1.zip
http://www.xl-logic.com/xl_files/charts/dynamic_chart_1.zip
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;147803

Cheers
Andy

P
Click to expand...
 
Back
Top