Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

Excel Graph -  how to create?

Posted on 2014-01-30
Medium Priority
97 Views
Say,

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
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
• 3
• 3

LVL 13

Assisted Solution

Ryan earned 1500 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

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

Ryan earned 1500 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

Author Comment

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

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

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 49

Expert Comment

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

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
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…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Suggested Courses
Course of the Month9 days, 19 hours left to enroll