| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Would Like Pivot Table Data on 1 Row instead of Stacked Column | Excel Discussion (Misc queries) | |||
| Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
| How can I create one column (stacked) from a large table of data.. | Excel Worksheet Functions | |||
| Pivot table creates blank table | Charts and Charting in Excel | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
Linear Mode
