Apple launches Apple Store app in India

The Apple Store app provides customers with the most personalized way to shop for Apple’s innovative lineup of products and services. Learn more >

You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Graphing a RUNNING TOTAL on a line graph

So I'm having a lot of trouble putting my data on a chart. I have it all laid out here: files.me.com/redsteven1/glwk4v.numbers.zip


Whenever I try to graph it though I run into a whole host of problems. Namely, that I can't get the values to plot on the chart at all.


Not sure what the problem is... I select A2:G103... and I see the different series (for each Activity) show up in the legend, but nothing is plotted on the chart.

I know that much of the table is blank... that's because I'll be adding to it every day.


Ideally, the X-axis should be time/date.... May, June, July, and August can be the major tick marks. And the Y-axis would be number of hours spent on each activity.


To further complicate things, the chart should really be a running total of time spent on each activity... so if I spend an hour on Activity 1 each day for 3 days... then on the third day I should have a plot of 3 hours... not 1.



I know I didn't work things super well here... hopefully you can figure out what I mean by looking at the linked file : \


Thanks in advance.

Unibody MBP, Intel iMac, Mac OS X (10.6.3), 15" Unibody MBP (2.53 GHz Core 2 Duo/4GB/512 MB 9600M GT), iMac

Posted on May 22, 2011 12:00 PM

Reply
Question marked as Top-ranking reply

Posted on May 22, 2011 12:26 PM

I guess that line graph isn't the best one, I would use the Scatter one.


You can't chart your datas as they are at this time.


Every datas are date_time or duration values which can't be charted as is.

User uploaded file

Here, I converted the dates from column A into strings

Then I added 6 columns in which I converted the durations into decimal hours.

The original columns are hidden.

The formula used to convert is a simple one.

In H2, I inserted :

=STRIPDURATION(B)*24


Fill to the right

Fill Down


to fill the other cells.


Yvan KOENIG (VALLAURIS, France) dimanche 22 mai 2011 21:26:18


Please :

Search for questions similar to your own before submitting them to the community


To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

2 replies
Sort By: 
Question marked as Top-ranking reply

May 22, 2011 12:26 PM in response to redsteven1

I guess that line graph isn't the best one, I would use the Scatter one.


You can't chart your datas as they are at this time.


Every datas are date_time or duration values which can't be charted as is.

User uploaded file

Here, I converted the dates from column A into strings

Then I added 6 columns in which I converted the durations into decimal hours.

The original columns are hidden.

The formula used to convert is a simple one.

In H2, I inserted :

=STRIPDURATION(B)*24


Fill to the right

Fill Down


to fill the other cells.


Yvan KOENIG (VALLAURIS, France) dimanche 22 mai 2011 21:26:18


Please :

Search for questions similar to your own before submitting them to the community


To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

Reply

May 22, 2011 8:19 PM in response to redsteven1

redsteven1 wrote:


To further complicate things, the chart should really be a running total of time spent on each activity... so if I spend an hour on Activity 1 each day for 3 days... then on the third day I should have a plot of 3 hours... not 1.

Yvan has provided the solution to getting the data onto the chart. This addresses your second issue above.


Numbers charts chart the data they are provided. If you provide data for individual days, the chart will show data for individual days. If you want the chart to show cumulative data over a period of days, then you must provide that data.


After adding the six columns shown by Yvan to convert the Duration values to numbers, Add an additional six columns to calculate the running totals and provide that data for the chart.


You'll now have columns B-G (original data), H-M (conversion to numbers) and N-S (cumulative totals for each activity).


In N2, enter the following:


=IF(SUM($H2:$M2)>0,SUM(H$2:H2),"")


Fill right to column S.

Fill down to all rows.


Result should be as below for data in your sample document.


User uploaded file


Regards,

Barry

Reply

Graphing a RUNNING TOTAL on a line graph

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.