ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   overplot of curve and bar graph (https://www.excelbanter.com/new-users-excel/122518-overplot-curve-bar-graph.html)

Bhaskre

overplot of curve and bar graph
 
How do I plot an Overplot? That is a curve on top of a bar graph.

Andy Pope

overplot of curve and bar graph
 
Hi,

Create a column (vertical bar) chart using both sets of data. Then right
click the column series you want to plot as a line. Pick Chart Type and
select Line style.

If bar (horizontal bars) then change to xy-scatter series and supply
both x and y values.

Cheers
Andy

Bhaskre wrote:
How do I plot an Overplot? That is a curve on top of a bar graph.



All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com