MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combination Bar/Line Charts: Need 1 bar and 5 Line, how?!


Posted by Steven on March 15, 2001 11:47 AM

I have data I need illustrated in a bar chart with fixed goal lines added as the line part of the chart. I need 4-5 of these goal lines. The chart only allows for two lines and shows all the other data as bars. How can I circumvent this? Thanks.


Posted by ml on March 15, 2001 12:09 PM

Right-click on any of the bar series that you want to change to
a line series, select "chart type" from the menu, then select the
desired line series style. Rinse and repeat.

Posted by Bob H. on May 08, 2001 10:42 AM

That is an awesome solution!!! I have been struggling with a similar problem for 2+ hours before checing this site. Works great!!! Thx!

Posted by Brad O. on April 10, 2005 2:31 PM

Re: Chart with stacked bars and lines

For this to work, the checkbox for "Apply to Selection" (under options) has to be checked. It took me a while to figure this out because it is not in an obvious place.