Andreasegeland
New Member
- Joined
- Jan 24, 2019
- Messages
- 4
Dear MrExcel community,
I have a problem where I am trying to extract values from a dynamic (i.e. input are likely to change) worksheet to specific charts. Now, the dynamic worksheet is my "Data Input" worksheet and I have several chart plots depending on this. What I need, is a smart way to update these charts when new and different data is added. All data are assigned to a category so it would not be hard to do this using a VLookup function however, I want to bypass this and directly extract the data I want to plot from the "Data Input" spreadsheet to my chart. So a neat solution without the extra "unnecessary" space the VLookup function would require.
I would like if it was in the form of an "Update plot" button that would be linked to a macro immediately updating my plots to the new input data.
I appreciate any tips or ways to get around this! (Excel 2007)
Kind regards,
Andreas
I have a problem where I am trying to extract values from a dynamic (i.e. input are likely to change) worksheet to specific charts. Now, the dynamic worksheet is my "Data Input" worksheet and I have several chart plots depending on this. What I need, is a smart way to update these charts when new and different data is added. All data are assigned to a category so it would not be hard to do this using a VLookup function however, I want to bypass this and directly extract the data I want to plot from the "Data Input" spreadsheet to my chart. So a neat solution without the extra "unnecessary" space the VLookup function would require.
I would like if it was in the form of an "Update plot" button that would be linked to a macro immediately updating my plots to the new input data.
I appreciate any tips or ways to get around this! (Excel 2007)
Kind regards,
Andreas
