Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
drop page fields here and drop series fields here
I have an OLAP chart ion my chart sheet.
On the bottom and top have drop page fields and seriers fields here. I have no idea which fields I can drag and drop. any information is great appreciated, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
drop page fields here and drop series fields here
Hi,
This chart is a pivotchart? If so the field list should be displayed. You can drag any field in the field list to any area, so your choice should be based on what you want to display and how you want to display it. Note that as you change the pivot chart the pivot table will also change and visa versa, so you can drag the fields around on the pivot table to see the effects on the pivot chart. -- Cheers, Shane Devenshire "Souris" wrote: I have an OLAP chart ion my chart sheet. On the bottom and top have drop page fields and seriers fields here. I have no idea which fields I can drag and drop. any information is great appreciated, |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
drop page fields here and drop series fields here
For an OLAP chart, in the field list, there are two kinds of fields. The
fields with numerical data (measures) have an icon with 1 and 0 symbols. These fields can go into the data area only, where they become the bars or lines in the chart. The other fields can go into any of the other areas of the chart -- the Page area, Series area or Category area. Changing the pivot chart will change the layout of the pivot table on which it is based. Souris wrote: I have an OLAP chart ion my chart sheet. On the bottom and top have drop page fields and seriers fields here. I have no idea which fields I can drag and drop. any information is great appreciated, -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
drop page fields here and drop series fields here
Thanks for helping,
"Debra Dalgleish" wrote: For an OLAP chart, in the field list, there are two kinds of fields. The fields with numerical data (measures) have an icon with 1 and 0 symbols. These fields can go into the data area only, where they become the bars or lines in the chart. The other fields can go into any of the other areas of the chart -- the Page area, Series area or Category area. Changing the pivot chart will change the layout of the pivot table on which it is based. Souris wrote: I have an OLAP chart ion my chart sheet. On the bottom and top have drop page fields and seriers fields here. I have no idea which fields I can drag and drop. any information is great appreciated, -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create drop down form fields in Excel? | Excel Discussion (Misc queries) | |||
How to use Drop down list to reflect a set of fields to be filled? | Excel Worksheet Functions | |||
Drop down selections and combining fields. | New Users to Excel | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
How to remove Drop Page Fields Here from Pivot Table | Excel Discussion (Misc queries) |