Unusual chart design - possible?

Gingertrees

Well-known Member
Joined
Sep 21, 2009
Messages
697
I've been asked to produce a chart based on sales data for 4 companies, across time. The design that was requested (sketched out for me, in fact) is unlike any I've ever seen in Excel. The idea is to have a bar chart, spanning 12 months time, with this year's data on top, and the prev. yr's data mirror-imaged below. So there would be POSITIVE numbers on both sides of the axis. For each calendar month, there would be a group of 4 bars representing the four companies. I tried to approximate it in the code below:
Code:
(the columns of X, W, P, and L represent sales from diff. companies.)
Say that the first column of Jan represents sales of $400 in 2012, $200 in 2011. 
In W, $200 in 2012, $300 in 2011.

2012
Jan                     Feb             Mar            A ...    Dec.
$4  $2    $4  $3        3  3  4  3
X         P                   P 
X         P    L        X  W  P  L
X    W    P    L        X  W  P  L
X    W    P    L        X  W  P  L
----------------------------------------------------------------------
X    W    P    L        X  W  P  L
X    W    P    L        X  W  P  L
     W    P             X     P
          P                   P 
$2   $3   $4  $2        3  2  4  2
Jan                     Feb            Mar             A ...
2011

Is this a possible chart design? How would I create it?
 
Hi Ginger Trees.

There is an easy change, but what if the difference is negative?

Would putting a Negative Percentage at the bottom be okay?

Like this?
Horizontal-Excel-Tornado-Chart-add-Percent-Change-Label2.png


Let me know.

Steve=True
 
Upvote 0

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
lol wow, two blog posts and videos! It must be a slow week for you. Or I have interesting problems. Thank you ever so much. Thanks to all your help, I was able to deliver exactly what was requested by 2 or more of my bosses. Have a great weekend, Steve=True!
 
Upvote 0

Forum statistics

Threads
1,226,385
Messages
6,190,701
Members
453,613
Latest member
mdarko

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top