Having to re-do graphs

[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?

 

[Andy Pope]

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

 

[Tushar Mehta]

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?

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

 

[Guest]

Thanks very much - I'll give it a shot!

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

 

[Guest]

Thanks for your help.

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