CODEWITHSUNDEEP
excelgraphcharts
Mefhisto1
Mefhisto1

Reputation: 2228

Stacked chart for budgeting example

I have data in three columns:

01.1.2010    Spent           555  
01.1.2012    Planned       34343  
01.1.2012    Spent          6565  
01.1.2014    Planned       34312  
01.1.2015    Planned        2323

I wish to create a stacked chart where the horizontal axis will have only dates, and if there's data, stack the planned amount and spent amount in one bar. So in this case I should have four columns and the column for 2012 date should be stacked with Planned first (one color) and Spent (different color).

How might I achieve this?

Upvotes: 1

Views: 229

Answers (1)

pnuts
pnuts

Reputation: 59485

Might be easiest to rearrange your source and then allow Excel to 'do its thing':

SO18739946 example

Upvotes: 1

Related Questions