sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 1,015
- Office Version
- 365
- 2016
- Platform
- Windows
Wow!! can you please share the step like how you have shown in post #8Is 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.
Sure! I will try it from my end and let you know if I have any questions by using the above method...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.