Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Trying to create this!

Hello    I'm trying to create this sketch below but I'm struggling.  I'm trying to create it using line and stacked bar chart but I can't get the lines to show as per below.  Does anyone have any s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Cherry 

 

Thanks very much for your response.  

 

Ok this is as far as i can get.  Two problems

 

1. I can't get the lines to stop partway across the graph or locate in the correct position.  The only way I could think of is arranging the data in a table with a value for the year where i want a line and no value where I dont want the line.  basic! 

 

2. I cant group the year 2018&19 / 20-22 / 23-28

 

Any suggestions would be a great help.  thank you

 

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

What about grouping the year firstly with New Group like below?

 

 

In addition, you could turn off the secondary Y axis under Y axis.

 

Here is my test result.

 

 

More details, you could refer to my attachment.

 

Best  Regards,

Cherry