Excel charts and updating data Friends who like hotsex chats
For example I have a stacked chart with two values; one is a target of 651,361 and one is an actual to date of 556,424.Obviously this shows that the actual are nearly at the target level (great!I know how to get vba open off the developer tab, but thats about it.Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.), yet the bar chart for the actual to date one is probably a third of the size of the target one which doesn't represent the figures.
How do you get excel to do that on its own, instead of me having to go into the Select Data and edit every series every time? Once you set the range, anything inserted into that range is taken into account.
All of the charts are fed from a table of various summary figures; these figures change - I just need the charts to fully change with them.
The data labels seem to be changing no problem, but the size and scope of some charts doesn't.
The data series is called "Strategy HPR", which I named manually using Select Data on the chart.
I have a macro that allows the user to select a date range on which to run a model, and then populates a range on the "Model" sheet with a column of dates and a column of output values from the model corresponding to each date.