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.
