Software

Ask something
Discussion Locked

Excel mixed chart

0 helpful
6 replies

by rona_nesler

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have 3 things to graph..This year's data, the goal for 2002 and the goal for 2003. I want the 2 goals to be lines and the data for this year (i.e. Jan 2003 and feb 2003) to be bars. So it will look like solid lines for goal 2002 and goal 2001 but bars for the actual data for 2003. I did a mised chart and got the last set of data to be a line but the first 2 are bars. How can I get 1 bar and 2 lines.

6 replies

by dklippert

Right click the data series and choose "Chart type". I think you mean columns rather than bars.

by firstpeter

Here's an ugly way of doing it:

Add a new column for data (assuming your years are columns):

Blank 2001 2002 2003
One 469 299 737
Two 482 834 127
Three 942 628 497
Four 605 956 158

Create a Custom chart, Line - Column on Two Axes. Select "Columns" as your source. You will get a chart with two columns and two lines ("Blank" should be a column, but should show no data). Then click on the Legend, then click on the "BLANK" label and delete it.

That'sthe way I've worked around it in the past. Hope that helps!

by firstpeter

Sorry - that table didn't show up too well. The "Blank" column should be just that - blank. The 469, 482, etc., belong under 2001, and so on.

This discussion is closed to new replies.