I've been given the task of producing a chart quickly and I'm not too familiar with this part of excel.
Basically I want a bar chart as attached showing the values of expenditure areas in each year. This part is ok I think.
I need to add a line showing the resources available in each year which will go down each year and cut into each bar showing what area isn't covered by resources. The data is in the file (highlighted yellow) but I'm not using this at the moment. Can I add a line in to show this?
Also is it possible to start the vertical axis at more than 0 so that the chart only shows say 100,000 up to 400,000 so that the smaller boxed are clearer?
Any help would be gratefully received. Many thanks.
Bookmarks