CraigG
Board Regular
- Joined
- May 1, 2005
- Messages
- 173
- Office Version
- 365
- 2007
- Platform
- Windows
- Mobile
Hello
I need to create a combined chart showing:
- a line graph with spend across each month eg, Jan £10,000, Feb £10,000, etc
- on the same chart a bar chart which only starts at the contract start date and ends at the contract end date but on the y axis with the contract value eg, if a contract starts on 1st Jan and ends on 31st Jul with a contract value of £100,000 then the bar will only show across Jan to Jul x axis and not in Aug to Dec and on the y axis with the contract value of £100,000.
Please see attached to see what I mean.
Thanks for your help.
I need to create a combined chart showing:
- a line graph with spend across each month eg, Jan £10,000, Feb £10,000, etc
- on the same chart a bar chart which only starts at the contract start date and ends at the contract end date but on the y axis with the contract value eg, if a contract starts on 1st Jan and ends on 31st Jul with a contract value of £100,000 then the bar will only show across Jan to Jul x axis and not in Aug to Dec and on the y axis with the contract value of £100,000.
Please see attached to see what I mean.
Thanks for your help.