I'll admit I'm not exactly what you'd call an excel guru, but I want to learn. Right now however I just want to solve my problem.
I am creating a personal account spreadsheet to watch where my money goes, and to keep track of my budget. The problem is I have a bar chart with that incidate my expenditure over 12 months. Then I have a line graph which cuts off at where I want my budget to be.
My issue is to get this line graph I have to create yet another series of data on my spreadsheet with a static number so I can get the series data. Is there a way I can just enter the series data on the chart so I don't have to have this extra line?
I realise I'm probably sounding like an idiot, so I've attached a small example* (at least I thought I did!)
(ps - I realise it seems awfully poor of me to just come on here and rattle off advice but I tend to learn better when someone shows me rather than sifting through books and web sites for the answer. That's not to say I haven't looked, but I just haven't found the answer - maybe I am looking wrong?)