Add Budget Line to Chart

[mc2468]

Hi,

I was wondering if someone could help me with the attached spreadsheet. What I'm trying to achieve is to add a budget line into the graph so it tracks both sales and budget figures. The data for this information is pull from the 2nd Sheet named "Gross Sales"

Any help would be much appreciated.

[humdingaling]

re-arrange your data so your pivot table works properly
its its current format its pretty bad to graph things

ps not sure why you used a stacked line graph instead of the regular line graph
it doesnt give you an accurate representation of what budget is?