how can i make a bar graph in numbers to track trends

Question

Level 1

1 points

how can i make a bar graph in numbers to track trends

I have a table with columns A-K. All the columns have needed data for other things. I need to track trends of incorrect input by staff. Column A has the date and column K has a 1 if incorrect or it's blank if correct. I only need to use the month as I need to track total incorrect for the month to see if there is a downward or upward trend as training progresses. (i need to create a line graph that shows the total incorrect per month) I will be tracking for a long period of time so would be nice if the graph updated as I input more info into the table.

Posted on Apr 28, 2014 7:36 AM

Reply

Answer 1

Top-ranking reply

a brody

Level 10

84,005 points

Apr 28, 2014 7:38 AM in response to puggers7

With what software?

Reply

Answer 2

Apr 28, 2014 8:46 AM in response to puggers7

Puggers,

What part of this problem are you having trouble with? making the chart? identifying entry problems?

Since you posted here I assume:

- you are using Numbers (what version?)

- you are on Mac OS X

If you have something started, please, post a screenshot using the informaiton here:

https://discussions.apple.com/docs/DOC-6591

Reply

Answer 3

puggers7 Author

Level 1

1 points

Apr 28, 2014 8:59 AM in response to Wayne Contello

I am using numbers in OSX mavericks. I am pretty much lost with applying the data. My date column has this format. ie. Jan 1, 2014. 07:30. And on down through the rows. To Apr 6, 2014 17:00. I can get months in the x axis but they start with June instead of Jan. And I can't get the count of "1" to total for each month? Does this give you a better picture?

Reply

Answer 4

Apr 28, 2014 9:01 AM in response to puggers7

Nope.

If you have something started, please, post a screenshot using the informaiton here:

https://discussions.apple.com/docs/DOC-6591

Reply

Answer 5

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:08 AM in response to Wayne Contello

I deleted the attempt as I couldn't get it to work. I am also very new to the macbook and numbers (used to excel as a beginner) don't even know how to do a screen shot with the macbook pro

Reply

Answer 6

Apr 28, 2014 9:11 AM in response to puggers7

No problem in being a beginner. Remake what you had up to the point where you need help then post that. If you just have a table, select the table, copy, then switch here and paste the table.

If you have something started, please, post a screenshot using the informaiton here:

https://discussions.apple.com/docs/DOC-6591

Reply

Answer 7

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:11 AM in response to Wayne Contello

the version of numbers is 3.2

Reply

Answer 8

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:13 AM in response to Wayne Contello

Jan 1, 2014 12:00:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Meyers, Rebecka - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 2, 2014 7:33:59 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Meyers, Rebecka - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 3, 2014 7:56:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
Jan 3, 2014 4:17:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	DIRTY	540.0
Jan 5, 2014 9:05:59 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 5, 2014 10:22:59 AM	APPENDECTOMY (PEDS)	Skarda, David - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 6, 2014 11:06:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.1
Jan 7, 2014 8:38:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 8, 2014 7:42:59 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 9, 2014 4:31:00 PM	APPENDECTOMY (PEDS)#1	Black, Richard - Pediatric Surgery	CONTAMINATED	541.0
Jan 10, 2014 9:14:00 AM	APPENDECTOMY (PEDS)#2	Black, Richard - Pediatric Surgery	CLEAN-CONTAMINATED	540.0	1
Jan 10, 2014 3:23:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)#3	Barnhart, Douglas - Pediatric Surgery	CONTAMINATED	540.9
Jan 12, 2014 11:09:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)#4	Barnhart, Douglas - Pediatric Surgery	CONTAMINATED	540.0	1
Jan 12, 2014 3:52:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)#5	Barnhart, Douglas - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 12, 2014 9:28:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)#6	Barnhart, Douglas - Pediatric Surgery	CONTAMINATED	540.9
Jan 13, 2014 5:47:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 13, 2014 7:19:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.9
Jan 14, 2014 12:52:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.0	1
Jan 16, 2014 7:33:00 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	DIRTY	540.9
Jan 16, 2014 8:25:00 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	DIRTY	540.0
Jan 16, 2014 10:51:00 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 17, 2014 7:58:59 AM	APPENDECTOMY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 18, 2014 4:49:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.9
Jan 19, 2014 8:19:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.9
Jan 20, 2014 7:30:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 20, 2014 9:43:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.9
Jan 20, 2014 11:16:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	DIRTY	540.0
Jan 20, 2014 12:48:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	NWCA	540.9	1
Jan 20, 2014 9:48:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CONTAMINATED	540.9
Jan 22, 2014 12:08:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CLEAN	540.9	1
Jan 22, 2014 5:38:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	DIRTY	540.0
Jan 24, 2014 9:46:00 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Jan 24, 2014 10:46:00 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	DIRTY	540.0
Jan 24, 2014 3:57:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 24, 2014 6:52:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	DIRTY	540.0
Jan 25, 2014 9:57:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	DIRTY	540.9	1
Jan 26, 2014 7:35:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CONTAMINATED	540.9
Jan 27, 2014 6:27:00 PM	APPENDECTOMY (PEDS)#3	Black, Richard - Pediatric Surgery	CONTAMINATED	540.0	1
Jan 27, 2014 7:31:59 PM	APPENDECTOMY (PEDS)#4	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Jan 28, 2014 3:55:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Jan 29, 2014 9:44:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CONTAMINATED	540.9
Jan 30, 2014 11:06:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Feb 2, 2014 1:55:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)#1	Skarda, David - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Feb 3, 2014 2:09:59 AM	APPENDECTOMY LAPAROSCOPY (PEDS)#2	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
Feb 3, 2014 2:38:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)#3	Rollins, Michael - Pediatric Surgery	CLEAN-CONTAMINATED	541.0	1
Feb 3, 2014 7:26:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)#4	Rollins, Michael - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Feb 5, 2014 7:24:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)#5	Rollins, Michael - Pediatric Surgery	CONTAMINATED	540.9
Feb 6, 2014 10:54:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CLEAN	540.9	1
Feb 6, 2014 8:25:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Feb 8, 2014 11:16:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CLEAN	540.9	1
Feb 9, 2014 12:32:59 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	DIRTY	540.0
Feb 9, 2014 8:16:59 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	DIRTY	540.0
Feb 11, 2014 9:30:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Feb 12, 2014 9:37:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CLEAN-CONTAMINATED	540.0	1
Feb 13, 2014 6:53:00 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	DIRTY	540.0
Feb 13, 2014 10:06:00 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Feb 16, 2014 7:41:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Meyers, Rebecka - Pediatric Surgery	CONTAMINATED	540.9
Feb 18, 2014 1:44:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	DIRTY	540.0
Feb 18, 2014 9:57:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.9
Feb 19, 2014 6:14:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.9
Feb 20, 2014 9:37:59 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Feb 20, 2014 1:55:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
2/22/14 9:04	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.0	1
Feb 23, 2014 2:34:00 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Feb 23, 2014 3:48:00 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Feb 24, 2014 4:58:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Feb 24, 2014 11:49:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CONTAMINATED	540.9
Feb 26, 2014 3:12:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Feb 26, 2014 11:38:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	DIRTY	540.1
Feb 27, 2014 10:35:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CONTAMINATED	540.9
Feb 27, 2014 7:20:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.1	1
Feb 28, 2014 7:31:59 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.9
Feb 28, 2014 5:42:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
Feb 28, 2014 6:54:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
Mar 1, 2014 3:52:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
Mar 2, 2014 3:50:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 3, 2014 3:50:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	DIRTY	540.0
Mar 3, 2014 5:22:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CONTAMINATED	540.9
Mar 5, 2014 12:55:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	542.0
Mar 5, 2014 5:13:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Meyers, Rebecka - Pediatric Surgery	DIRTY	540.1
Mar 5, 2014 6:57:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Meyers, Rebecka - Pediatric Surgery	CONTAMINATED	540.1	1
3/6/14 3:35 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CONTAMINATED	540.9
3/6/14 6:17 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
3/6/14 7:07 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
3/7/14 12:32 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Rollins, Michael - Pediatric Surgery	CONTAMINATED	540.9
3/8/14 9:53 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
3/11/14 5:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Meyers, Rebecka - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
3/12/14 4:21 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
3/12/14 7:47 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CONTAMINATED	540.9
Mar 17, 2014 9:43:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	DIRTY	540.1
Mar 19, 2014 10:33:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 20, 2014 4:58:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 20, 2014 6:23:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Barnhart, Douglas - Pediatric Surgery	CONTAMINATED	540.9
Mar 21, 2014 6:28:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.0	1
Mar 22, 2014 2:58:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.0
Mar 24, 2014 2:16:00 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Mar 24, 2014 5:56:59 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 24, 2014 9:09:00 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 24, 2014 10:15:59 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 25, 2014 9:00:00 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Mar 25, 2014 10:33:59 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Mar 25, 2014 11:43:00 AM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.9
Mar 25, 2014 7:22:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 26, 2014 7:35:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 26, 2014 11:14:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 27, 2014 10:33:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 27, 2014 1:04:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Black, Richard - Pediatric Surgery	DIRTY	540.0
Mar 27, 2014 2:06:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CLEAN-CONTAMINATED	540.9	1
Mar 28, 2014 12:55:59 PM	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CLEAN	540.1	1
3/30/14 8:10	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	DIRTY	540.0
3/30/14 9:02	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CLEAN	540.9	1
3/31/14 7:35	APPENDECTOMY (PEDS)	Black, Richard - Pediatric Surgery	CONTAMINATED	540.1	1
Apr 3, 2014 4:22:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
Apr 3, 2014 6:50:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
Apr 3, 2014 8:16:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	DIRTY	540.9
Apr 3, 2014 9:59:59 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Skarda, David - Pediatric Surgery	CONTAMINATED	540.9
Apr 5, 2014 10:55:00 AM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.1	1
Apr 6, 2014 7:02:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	CONTAMINATED	540.9
Apr 6, 2014 9:48:00 PM	APPENDECTOMY LAPAROSCOPY (PEDS)	Scaife, Eric - Pediatric Surgery	DIRTY	540.1

Reply

Answer 9

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:14 AM in response to Wayne Contello

It would be the first column with the date and the last column with the "1"

Reply

Answer 10

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:15 AM in response to Wayne Contello

All I Really need is one line on the graph not the two that the template put in it.

Reply

Answer 11

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:18 AM in response to Wayne Contello

User uploaded file t

Reply

Answer 12

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:19 AM in response to puggers7

This is what I get:

User uploaded file

Reply

Answer 13

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:20 AM in response to puggers7

Can't seem to copy the graph that I can generate without the data I need in it'

Reply

Answer 14

puggers7 Author

Level 1

1 points

Apr 28, 2014 9:27 AM in response to puggers7

User uploaded file

Reply

Answer 15

Apr 28, 2014 1:19 PM in response to puggers7

OK.

Name the table you posted "Data". To name the table single click (select) the table, then open the Table Formatter and check the "Table Name" checkbox:

Now add a new row at the top by clicking the row header contextual menu and selecting "Add Row Above":

Now select the menu item (from the same menu) for the new row 1 "Convert To Header Row":

Now enter the column Names that make sense:

Now create a new table by selecting the plain table from the "Table" menu:

Now make the table two columns by dragging the column control handle:

Now title the table "Monthly Summary"

Now make the first row and first column a header.

Now type in the column header names as shown in row 1:

A2=Jan 2014

A3=Feb 2014

this is shorthand for select cell A2 and type "Jan 2014" then enter. omit the first and last double quotes.

now select cell A2 and cell A3 then hover the cursor over the bottom edge, then drag the yellow circle down as needed (however many rows you need).

B2=COUNTIFS(Data::F, 1, Data::A, ">="&DATE(YEAR(A2), MONTH(A2), 1), Data::A, "<="&EOMONTH(DATE(YEAR(A2), MONTH(A2), 1), 0))

again... this is shorthand for select cell B2, then type (or copy and paste from here) the formula:

=COUNTIFS(Data::F, 1, Data::A, ">="&DATE(YEAR(A2), MONTH(A2), 1), Data::A, "<="&EOMONTH(DATE(YEAR(A2), MONTH(A2), 1), 0))

now select cell B2, copy

now select column B, then hold the command key and click cell B1, to unselect

paste

now select column B, then add a bar chart from the charts menu:

Reply