View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Area Charts in 2007 - how to bring data set to front?

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

On 08/04/2010 14:09, dave n wrote:
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, Microsoft MVP - Excel
http://www.andypope.info