One line on a 6 data set Bar Chart

bluenuts81

New Member
Joined
May 10, 2007
Messages
3
I have a colleague looking to plot one line on a 6 data set Bar Chart.

The issue appears that when plotting on a Bar/Line chart the data set is split in two so that three sets are Bar Plots and three are Line Plots.

How would you go about plotting one line representing one data set across the 5 data set Bar?

Thanks in advance for the help.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Instead of selecting the Bar/Line chart when creating the chart, start out with the Bar chart. Then select the one series you want charted as a Line, right click the series and choose "Chart Type" from the dialog box, and select the Line chart. By selecting one series instead of the plot area, your change will be applied only to that series, not every series in the chart.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

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