Pivot table creates stacked column
in [Charts]
|
From: Catherine on 4 Mar 2010 16:40 I created a pivot table that shows the number of eligible and enrolled patients per month/year. When I create a graph of the data I can only create a stacked column graph. I want to create a regular column graph and have eligible and enrolled columns 100% overlap. Does anyone know how to do that with Excel 2003? Thank you. -- Catherine
From: Simeon on 4 Mar 2010 23:23 In 2007 you can select the series, right click => format data series, and one of the first options will be to chose spread/overlap. Not sure how is that in 2003. Sry On 3/4/2010 1:40 PM, Catherine wrote: > I created a pivot table that shows the number of eligible and enrolled > patients per month/year. When I create a graph of the data I can only create > a stacked column graph. I want to create a regular column graph and have > eligible and enrolled columns 100% overlap. Does anyone know how to do that > with Excel 2003? Thank you. > >
From: Catherine on 24 Mar 2010 19:09 Thank you. -- Catherine "Simeon" wrote: > In 2007 you can select the series, right click => format data series, > and one of the first options will be to chose spread/overlap. > Not sure how is that in 2003. Sry > > > > On 3/4/2010 1:40 PM, Catherine wrote: > > I created a pivot table that shows the number of eligible and enrolled > > patients per month/year. When I create a graph of the data I can only create > > a stacked column graph. I want to create a regular column graph and have > > eligible and enrolled columns 100% overlap. Does anyone know how to do that > > with Excel 2003? Thank you. > > > > > . >
|
Pages: 1 Prev: Change background / color of chart worksheet? Next: bars on chart do not match data points |