Pivot table creates stacked column

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.
 
S

Simeon

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
 
C

Catherine

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




.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table and Chart 1
stacked column graph adjacent to a regular column graph 0
Column & Stacked Columns 1
Creating a stacked column graph 2
Stacked column graphs and text displayed inside the columns 1
Move Data Series Manually 4
Stacked Bar Graph 1
How do I set up a clustered stacked column graph? Is it possible? 1

Top