Pivot table creates stacked column

  • Thread starter Thread starter Catherine
  • Start date Start date
C

Catherine

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.
 
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
 
Thank you.
--
Catherine


Simeon said:
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




.
 
Back
Top