Help - Chart Multiple Variables

Hi Guys,

Im working on doing a single chart with multiple variables.

The issue is that I have too many:

Years: 2012 - 2013
Total sales by region: Region 1 and 2
Teams: 1, 2 and 3
Sales and Market Share by team

I'm looking to do a comparison between the perfomance of the team in 2012 and 2013 and also a comparison between teams. I'm thinking of using the secondary axis for the market share % and the Y for sales. Im using excel 2010.

Thank in advance.

File attached

Nangys

I think you need to define what conclusions will the graphs help to arrive

Based on the data given I would analyze GROWTH or changes. The first table tells me that the market in region 1 grew 67% in 2013 from 2012 and 50% in region 2 for the same years. The team(s) that not grow at that pace lost % market share as shown in table 2. The Graphs will be more impacting

Total Sales 1.67 1.50
Team 1 1.67 1.50
Team 2 1.00 1.00
Team 3 1.00 1.00

Team 1 0% 0%
Team 2 -3% -17%
Team 3 -17% -10%

Rcm,

Thank you for your reply.

The objective of the chart is to visualize changes: 1) Market Share for each team (team1 2012 vs team2 2013) 2) If possible, give an idea of the "size" of the market (Total Sales by Region).

Which type of should would you use to do analyze growth with this data as you metioned?

I realiced the file had an error on the second table (The idea remains the same). Attached is the updated file with correct numbers.

Thanks

I inserted some graphs after I group the data

Thank you rcm

You gave me some ideas on a few ways to do it.