Charts

D

dipsy

Hi:

I have 2 columns - Visible Cost & Invisible Costs for 5
categories: Tech Cost, Facilities Cost, etc. I want to
plot this in the following manner:

For each category I want to plot the visible and invisible
costs. The chart will have a line in between with Visible
on the top in blue and invisible on bottom in red for each
category.

Any help is greatly appreciated.

Thanks.
 
D

Debra Dalgleish

Set up the data with categories in the first column, then Invisible,
then Visible.
Select a cell in the table
Click on the Chart Wizard button on the toolbar
Select the Column Chart type, and the stacked column subtype
Continue to the end of the Chart Wizard, selecting the options that you want
In the chart, click on one of the Visible categories.
Click the arrow to the right of the Fill Color button on the toolbar,
and choose the red colour
Click on one of the Invisible categories
Click the arrow to the right of the Fill Color button on the toolbar,
and choose the blue colour
 
Top