L
linda
Try selecting a column with a right click, then select
Chart Type. Go to the Standard type tab, and select
Column. Here you will see Column types... look and select
the stack column for $'s, not the 100% Stacked Column.
To change the color of the area, double click (normal) and
it will bring you to the Format Data Series area. You can
change the colors here. To change only one area in a
Series (maybe only one yr in Series one is negative),
select the column, wait, then select again and it should
highlight only one square... then double click and it will
bring you to the Format Data Series for only that square.
Good Luck!
.....Linda
Chart Type. Go to the Standard type tab, and select
Column. Here you will see Column types... look and select
the stack column for $'s, not the 100% Stacked Column.
To change the color of the area, double click (normal) and
it will bring you to the Format Data Series area. You can
change the colors here. To change only one area in a
Series (maybe only one yr in Series one is negative),
select the column, wait, then select again and it should
highlight only one square... then double click and it will
bring you to the Format Data Series for only that square.
Good Luck!
.....Linda