LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating "cliffs" in an area chart CurlerBob Charts and Charting in Excel 2 August 6th 08 03:00 AM
How to entre a "pattern" in a column chart? "used to be in 2003" Mecckey Excel Discussion (Misc queries) 1 June 7th 08 02:28 AM
How do I change the column heading in Excel to display "A" "B" "C Thai New Users to Excel 1 November 30th 07 08:06 PM
Why does excell switch my stock symbol "ACN" to "CAN"? garron Setting up and Configuration of Excel 1 June 21st 07 02:35 AM
Don't want the "All" option in the Drop Page Field of a pivot tabl Vincerix Excel Discussion (Misc queries) 1 May 12th 06 09:22 PM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"