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

  • Thread starter Thread starter dave n
  • Start date Start date
D

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
 
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
 
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.
 
That did it - thanks!

trip_to_tokyo said:
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.
Click to expand...
 
Back
Top