Solved

MS Excel - 2007 - Bar & Line Chart

Posted on 2011-09-06
7
355 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 31

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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) 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 31

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 31

Expert Comment

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

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

617 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