If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. . |
Thread Tools | |
Display Modes | |
|
|