Solved

MS Excel - 2007 - Bar & Line Chart

Posted on 2011-09-06
7
332 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

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…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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