Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic sourcedata when copying chart within sheet
Hi!
I'm working on a document that needs to allow the user to add more "rows" (a "row" contains a list of numbers and a chart depicting these numbers). The problem however is that when copy-pasting new "rows", the charts in the new "row" point to the numbers in the original "row" above. Is there a a way to make this operation userfriendly? A macro maybe? I tried to make some kind of macro but due to my limited skills I don't seem to get it right. For example, how do I select a specific chart from the new row (a row can contain up to 10 charts) when I don't know it's name? (Example: ActiveSheet.ChartObjects("Chart 7").Activate --- does not work, since Chart 7 isn't dynamic...) Any other solutions? BR, Josip |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic sourcedata when copying chart within sheet
Make a template that has one chart and one chart's bit of data. Save and
close the template. To add a new chart linked to a new data range: 1. Create a new file based on the template 2. Cut (not copy) the range containing the chart and data 3. Paste into the sheet with multiple charts. This pasted chart will link to the pasted data in the pasted cells. 4. Replace the pasted data with the data you need your new chart to plot. 5. Close the new workbook you created. Repeat as necessary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Hi! I'm working on a document that needs to allow the user to add more "rows" (a "row" contains a list of numbers and a chart depicting these numbers). The problem however is that when copy-pasting new "rows", the charts in the new "row" point to the numbers in the original "row" above. Is there a a way to make this operation userfriendly? A macro maybe? I tried to make some kind of macro but due to my limited skills I don't seem to get it right. For example, how do I select a specific chart from the new row (a row can contain up to 10 charts) when I don't know it's name? (Example: ActiveSheet.ChartObjects("Chart 7").Activate --- does not work, since Chart 7 isn't dynamic...) Any other solutions? BR, Josip |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic sourcedata when copying chart within sheet
On Jun 11, 4:23 pm, "Jon Peltier"
wrote: Make a template that has one chart and one chart's bit of data. Save and close the template. To add a new chart linked to a new data range: 1. Create a new file based on the template 2. Cut (not copy) the range containing the chart and data 3. Paste into the sheet with multiple charts. This pasted chart will link to the pasted data in the pasted cells. 4. Replace the pasted data with the data you need your new chart to plot. 5. Close the new workbook you created. Repeat as necessary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Hi! I'm working on a document that needs to allow the user to add more "rows" (a "row" contains a list of numbers and a chart depicting these numbers). The problem however is that when copy-pasting new "rows", the charts in the new "row" point to the numbers in the original "row" above. Is there a a way to make this operation userfriendly? A macro maybe? I tried to make some kind of macro but due to my limited skills I don't seem to get it right. For example, how do I select a specific chart from the new row (a row can contain up to 10 charts) when I don't know it's name? (Example: ActiveSheet.ChartObjects("Chart 7").Activate --- does not work, since Chart 7 isn't dynamic...) Any other solutions? BR, Josip Ah, cut... Excel works in mysterous ways. Need to work out some type of macro for this then |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic sourcedata when copying chart within sheet
Yes, Cut. If you Copy, the chart source doesn't change, it's still in the
copied location, and the chart isn't forced to update. It's the same with a whole sheet. Copying it doesn't work, but moving it does. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ Ah, cut... Excel works in mysterous ways. Need to work out some type of macro for this then wrote in message ... On Jun 11, 4:23 pm, "Jon Peltier" wrote: Make a template that has one chart and one chart's bit of data. Save and close the template. To add a new chart linked to a new data range: 1. Create a new file based on the template 2. Cut (not copy) the range containing the chart and data 3. Paste into the sheet with multiple charts. This pasted chart will link to the pasted data in the pasted cells. 4. Replace the pasted data with the data you need your new chart to plot. 5. Close the new workbook you created. Repeat as necessary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Hi! I'm working on a document that needs to allow the user to add more "rows" (a "row" contains a list of numbers and a chart depicting these numbers). The problem however is that when copy-pasting new "rows", the charts in the new "row" point to the numbers in the original "row" above. Is there a a way to make this operation userfriendly? A macro maybe? I tried to make some kind of macro but due to my limited skills I don't seem to get it right. For example, how do I select a specific chart from the new row (a row can contain up to 10 charts) when I don't know it's name? (Example: ActiveSheet.ChartObjects("Chart 7").Activate --- does not work, since Chart 7 isn't dynamic...) Any other solutions? BR, Josip Ah, cut... Excel works in mysterous ways. Need to work out some type of macro for this then |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel/chart/sourcedata - should let me set the left or right axis | Charts and Charting in Excel | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Copying chart to another sheet | Excel Worksheet Functions |