Excel charts and updating data
), 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.Last week it was slightly smaller which was more of an accurate representation, this week when I have updated the data source figures, the chart data labels showing each value on the bar chart as I say changes and is correct, but the bar chart is all out of proportion!
This file has taken 3 days of work and but is useless unless these graphs update smoothly for the user!) update fine, however the area / proportion of each chart doesn't.For example, last week, the figures for 'Allocated to A' were 37, the figures for 'Allocated to B' were 178.However, this week, the figure for 'Allocated to A' is 34 and the figure for 'Allocated to B' is 181; the data labels have automatically updated but the bar has a larger proportion allocated to A, which looks wrong!
Does anyone know why the areas of the charts don't update, just the labels? It is basically a workbook with three 'data source' tabs, so the data is dumped onto these tabs.Visit Stack Exchange If I were to have data in excel just like the table below, and then make line charts with that data.