Charts

  • Thread starter Thread starter dipsy
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top