| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Having to re-do graphs
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Having to re-do graphs
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Having to re-do graphs
In article , 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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Having to re-do graphs
Thanks for your help.
"Tushar Mehta" wrote: In article , 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HYPERLINK GRAPHS | Charts and Charting in Excel | |||
| Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
| Charts and Graphs disappearing | Charts and Charting in Excel | |||
| Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions | |||
| Help! My graphs sneezed! | Charts and Charting in Excel | |||
Hybrid Mode
