Area Charts in 2007 - how to bring data set to front?

[dave n]

I have an area chart where one set of data is larger than another and hiding
the smaller set. How can I bring the smaller data set to the front so it is
visible also?
Thx
Dave

 

[Andy Pope]

Hi,

You can change the plot order of the series via the Select Data dialog.
Chart Tools > Design > Data > Select Data.

Select the series and use the up/down buttons to swap plot order.

Cheers
Andy

 

[trip_to_tokyo]

Dave one way to do this is to change the transparency levels of your data.

Take a look at:-

http://www.pierrefondes.com/

Item number 73 (an Area Chart).

Look at the Method tab and pay particular attention to my points number (in
Column A) 10, 11 and 12.

I think this will give you what you want.

If you agree please hit Yes.

Thanks.

 

[dave n]

That did it - thanks!

Dave one way to do this is to change the transparency levels of your data.

Take a look at:-

http://www.pierrefondes.com/

Item number 73 (an Area Chart).

Look at the Method tab and pay particular attention to my points number (in
Column A) 10, 11 and 12.

I think this will give you what you want.

If you agree please hit Yes.

Thanks.