ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to know when to use category and series fields correctly (https://www.excelbanter.com/new-users-excel/193444-how-know-when-use-category-series-fields-correctly.html)

ultrasounds4u1

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

tim m

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



All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com