Forum Discussion
Automatically selecting the new data for charts (dynamic arrays)
I have an excel sheet that automatically pulls in the new data that i want and adds it to the next available row. I have several charts that are associated with this data and right now i have to go t...
If you can change the data source of the charts to a table, you won't need any code.
Another option is to create dynamic named ranges for the x-values and y-values.
I agree that those are ways to try and do it with a table. The Issue i am running into is that for most of the cells that i would need to include into the table have equations already in them. these cells are pre-allocated with the equations so that when it pulls in the new data all the calculations are automatically done. The problem with the table method is that it doesn't grab just the information that I want at this time to be in the graph. which is why i am trying to create an index system to select appropriately.
If a table isn't suitable, try dynamic named ranges.
