TheyCallMeIke
New Member
- Joined
- Nov 4, 2010
- Messages
- 34
Hi All,
I have a spreadsheet for yearly claims adjustment count with each month broken into its own tab(worksheet).
I am trying to create a Line graph based on the total row count (variable) for each month, and was wondering what the formula would be to accomplish this?
So I would need the formula to look at janruary tab, february tab, etc. and grab the total row count that has data entered, and put that count into a graph.
so if:
Jan tab has 587 rows of data
Feb tab has 600 rows of data
Mar has 300 rows of data
then the formula will grab those counts and display it into the chart format
What would be the formula I need to put into the graph to do this?
Thanks for anyone that can provide some feedback.
I have a spreadsheet for yearly claims adjustment count with each month broken into its own tab(worksheet).
I am trying to create a Line graph based on the total row count (variable) for each month, and was wondering what the formula would be to accomplish this?
So I would need the formula to look at janruary tab, february tab, etc. and grab the total row count that has data entered, and put that count into a graph.
so if:
Jan tab has 587 rows of data
Feb tab has 600 rows of data
Mar has 300 rows of data
then the formula will grab those counts and display it into the chart format
What would be the formula I need to put into the graph to do this?
Thanks for anyone that can provide some feedback.