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?

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?