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.
This posting is provided "AS IS" with no warranties, and confers no rights.
> 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
> 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?