Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Disabled "Switch Row/Column" when creating chart from a pivot tabl
I have a pivot table where there are week numbers and three different data
values pr week. This I want to graph so that the weeks are on the X-axis, the values on the Y-axis and a legend telling which of the three datasets are which. When I create a Line graph the weeks are put as a legend and the X-axis have the three different datasets grouped. This is not what I want. When I go into "the "Select data..." dialog box all the options are disabled. Why is this and how can I get the graph to show the way I want? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Disabled "Switch Row/Column" when creating chart from a pivot tabl
You will need to pivot your pivot table to move the row fields to the columns
and vice versa. The pivot chart is designed to have consistentcy with the pivot table layout, so switch row/column is not enabled for this scenario. -- Thanks, Christopher This posting is provided "AS IS" with no warranties, and confers no rights. "Gunder" wrote: I have a pivot table where there are week numbers and three different data values pr week. This I want to graph so that the weeks are on the X-axis, the values on the Y-axis and a legend telling which of the three datasets are which. When I create a Line graph the weeks are put as a legend and the X-axis have the three different datasets grouped. This is not what I want. When I go into "the "Select data..." dialog box all the options are disabled. Why is this and how can I get the graph to show the way I want? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating "cliffs" in an area chart | Charts and Charting in Excel | |||
How to entre a "pattern" in a column chart? "used to be in 2003" | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
Don't want the "All" option in the Drop Page Field of a pivot tabl | Excel Discussion (Misc queries) |