Solved

Excel Graph -  how to create?

Posted on 2014-01-30
8
89 Views
Last Modified: 2014-10-29
Say,

please see attached xls.

Can you plot a 2 way comparison showing each branch in a bar graph of current month and previous years same month? The data is spend per Branch and wish to compare year on year differences per Branch.
Branch-TotalsChart-14-months.xlsx
0
Comment
Question by:shaunwingin
[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
  • 3
  • 3
8 Comments
 
LVL 13

Assisted Solution

by:Ryan
Ryan earned 500 total points
ID: 39820825
You already have a pretty nice chart showing the difference of 1 month to prev year?

You want a graph showing both months for each department?  You already have the work done for that, just need a graph to reference  Col R and S instead of T.
0
 

Author Comment

by:shaunwingin
ID: 39821020
tx - but sorry I didn't create this graph - can you perhaps action it so I can see how its done as I'm rather new to them.
0
 
LVL 13

Accepted Solution

by:
Ryan earned 500 total points
ID: 39821418
Check out the equation in R3 and S3.  It utilizes INDEX() and MATCH() formulas referencing the date in R2. The sheet with the chart that has a date dropdown is linked to R2 on the data sheet.

The chart is simply using the data and displaying as a horizontal bar graph. The chart itself is nothing special.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:shaunwingin
ID: 39823451
tx - sorry how do I get to view the equation ie what tab do I use etc.
Perhaps you can implement and resend the excel sheet - then I can easily see what you suggest.
0
 
LVL 13

Expert Comment

by:Ryan
ID: 39823932
The equation is on the first sheet in columns R and S.

I don't know what you want implemented, There's already a chart on the 2nd sheet.
0
 

Author Comment

by:shaunwingin
ID: 39836783
Can you please modify the attachment above and plot a 2 way comparison showing each branch in a bar graph of current month and previous years same month? Wish to compare year on year differences per Branch.
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 40411476
I've requested that this question be deleted for the following reason:

The question has either no comments or not enough useful information to be called an "answer".
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

761 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