Solved

MS Excel - 2007 - Bar & Line Chart

Posted on 2011-09-06
7
325 Views
Last Modified: 2012-05-12
Is there a way to have a bar chart with a crossing line in the same chart?

For example, if I've got four columns on three rows, I want to have four bars representing the for columns in my chart and a line representing one of the rows (I choose).

Thank you!
0
Comment
Question by:feesu
7 Comments
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 100 total points
ID: 36487455
Is this what you are looking for?
columns-line.xls
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 36487457
you will have to change the number in column A to select the desired row
0
 
LVL 29

Assisted Solution

by:gowflow
gowflow earned 100 total points
ID: 36487488
Is this what your looking for ?
years are in bar and the total (in this example it could be any other column) is in line.
gowflow
Graph.xlsx
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 50

Accepted Solution

by:
teylyn earned 300 total points
ID: 36487873
Hello,

I assume you know how column/line charts look and you would like to learn how to create a chart like the ones posted in the sample files above.

Here are some tips:

- Select the data and click Insert > Column Chart. All data will now be columns in the chart. Depending on the source data, the chart will look something similar to this:

column chart
- Click the column in the chart that you want to change to a line, for example the purple column for "Average"
- right-click and select "Change Series Chart Type" and then select a line chart

 change chart type for one data series
- Click OK and the chart will look like this

 Combination column / line chart
cheers, teylyn
0
 
LVL 29

Expert Comment

by:gowflow
ID: 36487879
tks teylyn for beeing a good teacher !
gowflow
0
 

Author Closing Comment

by:feesu
ID: 36487919
For the good teacher :)
0
 
LVL 29

Expert Comment

by:gowflow
ID: 36487938
she is our inspiration !!! :)
gowflow
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now