Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Problems with Charts
I have a drop down list in a large group of data that now needs to be used in
a chart. Every time I create a pivot table all it does is count how many items are in the list. I need it to instead count the specific items that were selected. How do I do this? For example a drop down list of three letters were created 'a', 'b' and 'c.' In many different rows of data the following were selected 3 letter 'a,' 8 letter 'b' and 12 letter 'c' . I need the chart to display that three 'a' were selected, eight 'b' were selected and twelve 'c' were selected. I have tried numerous steps to make this work, I would appreciate some advice please. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Problems with Charts
Put the field name for the a, b, c column in the pivot table's row area.
Then, drag another copy of that field to the pivot table's data area, and you should see the letters, and a count for each letter. denise11559900 wrote: I have a drop down list in a large group of data that now needs to be used in a chart. Every time I create a pivot table all it does is count how many items are in the list. I need it to instead count the specific items that were selected. How do I do this? For example a drop down list of three letters were created 'a', 'b' and 'c.' In many different rows of data the following were selected 3 letter 'a,' 8 letter 'b' and 12 letter 'c' . I need the chart to display that three 'a' were selected, eight 'b' were selected and twelve 'c' were selected. I have tried numerous steps to make this work, I would appreciate some advice please. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validation problems... | Excel Discussion (Misc queries) | |||
Validation and If Function Problems | Excel Worksheet Functions | |||
Data validation problems | Excel Worksheet Functions | |||
Problems with Charts | Excel Discussion (Misc queries) | |||
Validation Problems | Excel Worksheet Functions |