Charting in Columns

[AJ]

Hi
I have sales figures of two departments in columns on a monthly basis.
The third column is the monthly total for these two departments.
How can I show all this data in a single columnar chart?
For eg. 'A' sales figure for Jan is $500
'B' sales figure for Jan $1000
'C' total sales Jan is $1500
assuming that X axis is months and Y axis is amount in $
Is it possible to show this data in a columnar chart or any other type of
chart the way that I want to?
Many thanks in advance

 

[BoniM]

Select only the data for your department sales (not to include the total
column) and create a stacked column chart. In 2007, you would go to Insert,
Charts, and Launch the Charts dialog box by clicking the button to the right
of the Charts label. Then select the stacked column chart type. In earlier
versions, click the Chart Wizard button and Stacked column is the second one
on the first row under chart subtypes for Column charts. A stacked column
chart will display the sales for each department with a different color for
their portion of the column, but the height of the stack will indicate the
total sales for January.