Chart with multiple line and columns

[Anonymous]

dear All,

I'm trying to build a chart that presents planed vs accomplished revenues and compare them year by year, something similiar to the chart below where:

dashed lines presents planed revenues in two years

columns represents accomplished revenues in two years

As for now i managed to build chart that is below but i can't add another line:

Below is my data. Can anyone please help me to build desired chart?

Best regards

[Gordonlilj · Accepted solution]

Hi,

Just to clarify, do the lines each represent a year, so one dashed line is the accomplishment for 2018 and the other for 2019. If that's the case than you could just create two calculated columns like

accomplished2018 = if(Sheet1[Budgettype] = "Budget 2018",Sheet1[Accomplisment])

accomplished2019 = if(Sheet1[Budgettype] = "Budget 2019",Sheet1[Accomplisment])

And then just add both of them to line values

[Anonymous]

Thank you very much, that's the solution that i was looking for!