Need chart as per image

sksanjeev786

Well-known Member
Joined
Aug 5, 2020
Messages
1,015
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
 

Attachments

  • image (2).png
    image (2).png
    89.7 KB · Views: 19
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.
Wow!! can you please share the step like how you have shown in post #8
like how to get that line beside bar chart....

Thank you so much for your time and hard work :)
 
Upvote 0

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
In my previous message, I wrote how the graph was constructed. Both graphs (histogram and line) are plotted along the same axis. Due to the fact that the values for the “line” graph are small, it is located almost at the axis.
To display both a histogram and a line on one chart, you need to go to the menu to change the chart type, and in the window that appears, select the last item “combo”. Next, for each, select the required type.
 
Upvote 0
In my previous message, I wrote how the graph was constructed. Both graphs (histogram and line) are plotted along the same axis. Due to the fact that the values for the “line” graph are small, it is located almost at the axis.
To display both a histogram and a line on one chart, you need to go to the menu to change the chart type, and in the window that appears, select the last item “combo”. Next, for each, select the required type.
Sure! I will try it from my end and let you know if I have any questions by using the above method...

Thank you so much for your support on this :)
 
Upvote 0

Forum statistics

Threads
1,226,504
Messages
6,191,425
Members
453,657
Latest member
DukeJester

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top