Chart Types

  • Thread starter Thread starter Mimi
  • Start date Start date
M

Mimi

Is there any way in which I can do the following:

I have 5 companies, each have a rate for month 1 & 2, for
5 models.

I would like to show the following
y-axis - rate(£)

Column 1 - model 1, company 1, month 1
Column 2 - model 1 company 1, month 2
Column 3 - model 1 company 2, month 1
Column 4 - model 1 company 2, month 2
etc
Column 11 - model 2 company 1, month 1
Column 12 - model 2 comapny 1, month 2

Is this possible? Any suggestions I want to compare each
companies rates for both dates for each model.

Many thanks
 
5 companies, 5 models, 2 months: 5 x 5 x 2 = 50 data points. Your list
only indicates 12 data points.

You could arrange your data something like this (I will assume it's not
50 points, which would make a hard to understand chart):

June July
Company 1 Model 1 [rate] [rate]
Model 2 [rate] [rate]
Model 3 [rate] [rate]
Company 2 Model 1 [rate] [rate]
Model 2 [rate] [rate]
Model 3 [rate] [rate]
Company 3 Model 1 [rate] [rate]
Model 2 [rate] [rate]
Model 3 [rate] [rate]

The cells above Company 1 and Model 1, to the left of June, are
completely blank. Select this entire range, including top row with
months and blanks, company and model listings, and rates, and use the
Chart Wizard to make a clustered column chart. That should get what
you've described.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top