Forum Discussion
Chart with multiple line and columns
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
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
2 Replies
GordonliljSolution Sage
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