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