Excel Charting Problem

  • Thread starter Thread starter Maureen
  • Start date Start date
M

Maureen

First timer here so here goes.
I have the following rows of data which I think I would like to char
as 2 adjacent stacked columns per month. The rows are NetSales(A)
Gross-NetSales(A), NetSales(B) and Gross-NetSales(B). I want the
NetSales values to be columns adjacent to each other and th
Gross-NetSales values to be above their respective NetSales values an
I want the 2 columns to be for each month (X-axis). Result would be
pair of stacked columns for each month.
Aim is to show, for a customer, whether or not sales have changed ove
time for each of ranges A & B.
Any ideas
 
Maureen,

You can do this by setting up your data in the following
columns:
A) Month
B) Data A/B
C) NetSales
D) Gross-NetSales

Your table rows and columns should look something like this:
| A | B | C | D |
1 |Month Data A/B NetSales Gross-NetSales
2 | jan a 2000 3000
3 | b 2500 3500
4 |
5 | feb a 2100 3100
6 | b 2600 3600
7 |


When you choose your chart make sure you choose a stacked
column chart. In Excel 2002 I chose the middle chart in the
top row of chart options for column charts.

When you get the chart on the page right click on one of
the chart columns, then click Format Data Series. Click the
Options tab and change the "gap width" to 0.

This will get you close to what you want. You should be
able to customize it from there.

~~Charles Osborne
 
Back
Top