Thread: Having to re-do graphs

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/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

In article <B659E501-23C1-46C9-84F6-1E538241E12D@microsoft.com>, galatea2153
@discussions.microsoft.com says...
> 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/ne...ynamic_charts/

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Thanks for your help.

"Tushar Mehta" wrote:

> In article <B659E501-23C1-46C9-84F6-1E538241E12D@microsoft.com>, galatea2153
> @discussions.microsoft.com says...
> > 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/ne...ynamic_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" wrote:

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