View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Gunder Gunder is offline
external usenet poster
 
Posts: 5
Default 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?