Need chart as per image

[sksanjeev786]

Hi Team

I need a same chart mentioned in the attached file

bar chart I am able to get but 25% line I am not able to get in the chart

Can anyone help me with this

 

[Sergius]

Hello! The line in your photo is an extension line. Used when you need to show data to make the chart easier to read.

 

[sksanjeev786]

Hello! The line in your photo is an extension line. Used when you need to show data to make the chart easier to read.

Hi Sergius,

Thanks for the below update.

so can we have the same type of chart? as I tried with line chart but getting horizontal line but not getting vertical line as per the screenshot

Regards
SAnjeev

 

[Sergius]

Draw a line graph along the secondary axis.

 

[sksanjeev786]

Draw a line graph along the secondary axis.

Hi Sergius,

So do we need to create th line while using chart or I need to take a line from shape and draw as per the image?

Regards
Sanjeev

 

[Sergius]

Hello! The values for a line graph should be taken from a table and not drawn by hand. If you showed your table (a small fragment with test data) and what data you want to display on the chart, it would be much easier.

 

[sksanjeev786]

Hello! The values for a line graph should be taken from a table and not drawn by hand. If you showed your table (a small fragment with test data) and what data you want to display on the chart, it would be much easier.

Hi Sergius,

If you dont mind can you please share the option in PPT I am a curios on how it will come automatically

Thanks in advance
Regards
Sanjeev

 

[Sergius]

As you can see in this diagram, the data from the ORDER column is plotted on an auxiliary scale, and the diagram type is selected as “line”

 

[sksanjeev786]

As you can see in this diagram, the data from the ORDER column is plotted on an auxiliary scale, and the diagram type is selected as “line”

Hi Sergius,

Thank you so much for your time. I am able to get the chart you have shown on the image, but I was looking for the picture I uploaded in which the lines are vertically arranged beside each chart. So, can that be possible via chart design?

 

[Sergius]

Is this what you meant?

If yes, then as I already wrote above, this is done using callouts. In the screenshot, both graphs are plotted along the same axis. But because COUNT values are large and ORDER values are small, the second graph will be almost at the axis. Therefore, to see the values, callouts are used.