Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to know when to use category and series fields correctly
I am trying to figure out what options are available when you plug in
specifice information to fields. I need to be able to look at specifice information by month and by procedure code. So does that need to be on the series axis or category or etc.? I keep getting all the information for the year listed and I am not able to list it for individual months. When I try to group for a month it says group is not allowed. Can someone tell me what I am doing wrong? Thanks -- ultrasounds4u |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to know when to use category and series fields correctly
Not 100% sure of the problem, do you have a number of rows each with a month
in one column and procedure code in another? example a1: January b1: 3467 a2: february b2: 7895 You can use auto filter on the headings of your data (top row) then when you filter you can choose to look at just one month out of all your data. "ultrasounds4u1" wrote: I am trying to figure out what options are available when you plug in specifice information to fields. I need to be able to look at specifice information by month and by procedure code. So does that need to be on the series axis or category or etc.? I keep getting all the information for the year listed and I am not able to list it for individual months. When I try to group for a month it says group is not allowed. Can someone tell me what I am doing wrong? Thanks -- ultrasounds4u |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop page fields here and drop series fields here | Charts and Charting in Excel | |||
Query on Category & Sub-category | Excel Discussion (Misc queries) | |||
Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Changing the layout of a series of fields from Column to row | Excel Discussion (Misc queries) |