Pivot table creates stacked column
 

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

Pivot table creates stacked column
 

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.

Pivot table creates stacked column
 

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.


.