Area Charts in 2007 - how to bring data set to front?
in [General]
|
Prev: I have an excel file split 1 and 2 how do I restore it please ?
Next: Keyboard shortcut for Auto-filter
From: dave n on 8 Apr 2010 09:09 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
From: trip_to_tokyo on 8 Apr 2010 09:46 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" 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
From: dave n on 8 Apr 2010 09:53
That did it - thanks! "trip_to_tokyo" wrote: > 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" 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 |