Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    mac


Advertisements:






Numbers 09 :: Create Chart With Dates (as Dates - Not Evenly - Spaced Labels) Along X-axis


i'm having a terrible time trying to figure out how to create a chart with dates (as dates — not evenly-speaced labels) along the x-axis. i have a column of dates and a column of values. i select both columns. then i either click the charts-->scatter button on the toolbar or select insert-->chart-->scatter from the menu bar. this produces, oddly enough, two different kinds of tables with different editable properties, NEITHER OF WHICH allows me to set the x-axis to the date format.

Information:
iMac / iBook / iPhone
Mac OS X (10.5.2)


View 7 Replies (Posted: Jun 17, 2010)

Sponsored Links:

Related Forum Messages for Mac:
Numbers 09 :: How To Create A Chart With Dates
I've created a table with projects I have to deliver and the date they were delivered. I would like to create a chart from this data - however I can't figure out how to use date in the chart.

Ideally the chart would work with the date (lets say from jan 01 to april 5) on the x-axis and the project on the y-axis. And a line that goes from time A (which marks the initial part of the project) to the time B (which marks the delivery date) defined on the table.

Information:
imac 3.06 intel core 2 duo 27"

Posted: Jan 17, 2011

View 13 Replies!   View Related
Numbers 09 :: How To Get X Axis Not To Add Dates
My X axis is made up of dates that I ran on.

My Y axis is the average pace in minutes per km that I achieved on the given date.

I usually run 4 or 5 days a week, and so my chart naturally has some days missing. for instance on row might have April 4, 2009. The next row down might say April 6, 2009 if I did not run on the 5th.

Information:
numbers 09

Posted: Apr 8, 2009

View 2 Replies!   View Related
Numbers 09 :: Having X Axis With Dates And A Variable Distance Between Them?
I've built a weight tracking spreadsheet with Numbers'09.

In the x axis I have the date (day) the measurement was made; in the y-axis the weight.

If one day (say 15 June) I make no measurement, then I'd expect that the horizontal distance in the graph between the day before (14 June) and the day after (16 June) to be twice as big as between consecutive days.

Information:
MacBook Pro 2,16 Core 2 Duo
Mac OS X (10.4.10)

Posted: Jun 18, 2009

View 4 Replies!   View Related
Numbers 09 :: How To Create A Double Y Axis Bar Chart
I have a table with 3 columns, how to create a double Y axis bar chart with title and scale of one Y axis on one side and the other title on the other side, left and right side of the chart.

Information:
iMac 27
i7

Posted: Oct 18, 2010

View 1 Replies!   View Related
Numbers 09 :: How To Create Leader Lines For Pie Chart Labels
The restriction of only being able to move a label of a wedge on a parallel axis is ridiculous. Here Excel clearly out shines Numbers.

I want an option to add a leader to a "Value" label so I can move it away from an area that is too crowded or the space for it is limited.

Information:
MacBook Pro (Multi-Touch) / 3G IPhone v 2.2
Mac OS X (10.5.6)

Posted: Aug 11, 2009

View 12 Replies!   View Related
Numbers 09 :: Shifting X-axis Labels - Displayed On Y-axis At 0?
Is it possible to shift the labels for the x axis to have them displayed on the y axis at 0?

Information:

Posted: Apr 20, 2010

View 1 Replies!   View Related
Numbers 09 :: Formatting Dates ?
I'm trying to create a schedule, and I want the row across the top to have dates in it. The catch is that I want them to be the date of the first day of each week. (ex. 1/4/10-1/11/10-1/18/10 and so on)

Posted: Nov 12, 2009

View 2 Replies!   View Related
Numbers 09 :: Calculating Dates On Spreadsheet
Is there a way with Numbers that on a spreadsheet I could create a formula which would automatically insert a date to criteria?If I want to release a product on, say 01 Oct 2010 and I know that I need my suppliers to receive it 5 weeks prior, and my office to be alerted 10 weeks prior, would there be a formula which could automatically work this out?

Information:
MacBook Pro
Mac OS X (10.6.4)
G4, MacBook, iPhone

Posted: Jun 18, 2010

View 8 Replies!   View Related
Numbers 09 :: How To Add Consecutive Dates Across Spreadsheet
Starting with one date as a column header, how can I automatically create consecutive dates across the spreadsheet (as column headers) that are exactly one week apart?

Information:
MacBook
Mac OS X (10.5)
HP 712C deskjet printer

Posted: Mar 26, 2010

View 1 Replies!   View Related
Numbers 09 :: Using Dates As Series In Plot Rather Than Categories
Is it possible to plot a graph with dates along the x-axis behaving as a series rather than a +category+? The reason for this is so that if you have missing dates, the dates are still plotted in their correct positions along the x-axis (as in an x-y scatter graph) and not just listed one after the other (as categories would be).

Information:
Mac OS X (10.6.3)

Posted: May 11, 2010

View 1 Replies!   View Related
Numbers 09 :: Coordinating Dates With Ical Events?
I have iWork 09 and I am looking for on how to coordinate calendar dates in the columns of my Numbers spreadsheets with my iCal and iPhone so that I will receive reminders of upcoming dates and deadlines.

Information:
Mac Book Pro
Mac OS X (10.6.4)

Posted: Nov 4, 2010

View 4 Replies!   View Related
Numbers 09 :: Moving Axis Top Of The Chart
I created a chart and can format it fine, except for I can't ever get the x-axis on top of the chart. Lets say your data points are decreasing from 0 on the y- axis but it still ends at the drawn "x-axis" at the bottom of the chart instead of the top and makes it loook like it is decreasing to 0. Called appel went by the genius bar, no one can figure it out is it even possible?

Information:

Posted: Oct 30, 2010

View 6 Replies!   View Related
Numbers 09 :: Count Number Of Mondays In A List Of Dates?
I would like to count the number of Mondays (or any other weekday) in a list of dates. I would like to do this without creating an additional column.

Information:
Mac OS X (10.5.6)

Posted: May 5, 2009

View 1 Replies!   View Related
Numbers 09 :: Graphic Display Of Data (Dates Against Readings)
Dates Reading
19/12/06 - 21/03/07 273
21/03/07 - 18/05/07 49
18/05/07 - 30/07/07 37
30/07/07 - 18/09/07 24
18/09/07 - 16/10/07 29

Above is a small section of data that I wish to display graphically either as a pie of bar chart or anything that shoes the dates against the reading however I can't get the dates to show up on the chart against their respective readings. I've tried formatting the cells to show the date but to no avail. Sorry but the word "Reading" should appear above the column of number beginning with 273 but I can't get it to do it here on this post.

Information:
iMac G5 PCC
Mac OS X (10.5.3)
iPod Mini. iPod Video 80GB/30GB. iTouch. Windows Vista PC. iPod Shuffle 2G. MBP

Posted: May 11, 2009

View 19 Replies!   View Related
Numbers 09 :: Conditional Formatting With Dates - Adding Totals?
I have a budgeting spreadsheet of which has some dates in the future, such as paydays. I want to have these events in the spreadsheet, but I don't want them to be in the formula until the date is due or passed. For example, my payday is 01/10/2010 but that's not been met, so the formula needs to ignore this when adding totals. I've looked at the conditional formatting option, I see it has dates but whenever I chose an option, such as 'the date' and select a future date, the spreadsheet total does not change.

Information:
Macbook Pro Core i7. 17"
Mac OS X (10.6.4)

Posted: Sep 2, 2010

View 18 Replies!   View Related
Numbers 09 :: Using Second Y-Axis Chart - Values In Reverse Order
In excel when I chart with a second axis I can have one set of values display in "reverse" order... How can I get same in Numbers?

Information:
MacBook Pro, iMac, iMac G5, iPod, Express, Extreme x2
Mac OS X (10.6.1)

Posted: Oct 8, 2009

View 2 Replies!   View Related
Numbers 09 :: Change Format For Dates Shown In Edit Bar
I am trying Numbers out as a replacement for Excel. But there is one annoyance that I don't like. I have a date column (formatted as a UK date DD/MM/YY). However when I select the date to edit it the date shown in the formula/edit bar is shown with the month in character form, e.g. 04 Jul 09. I find this annoying and I want the date shown there as an all digits date like with the value displayed in the cell. Does anyone know if I can change this?

Information:
Numbers 09
Mac OS X (10.6)

Posted: Sep 25, 2009

View 5 Replies!   View Related
Numbers 09 :: Importing CSV Dates - Wrong Format Styles?
I have some CSV data I want to import into Numbers and the CSV has dates. I work with "British" style dd/mm/yy dates but the CSV is "American" mm/dd/yy. How can I persuade Numbers to translate between the two styles?

Information:
iMac 27
Mac OS X (10.6.5)

Posted: Jan 4, 2011

View 1 Replies!   View Related
Numbers 09 :: Make Y-axis Title In Chart Horizontal Instead Of Vertical?
How do i make the Y axis title in a chart horizontal instead of vertical? I can change the angle of the number scale along the axis but i can't change the axis title....

Information:
macbook
Mac OS X (10.5.7)

Posted: Jun 3, 2009

View 1 Replies!   View Related
Numbers 09 :: Creating Line Chart With Value Axis (y) With Minimum Value Of - 10 And Maximum Value Of 100
I am creating a line chart with a value axis (y) with a minimum value of -10 and a maximum value of 100. I would like the axis to read 0, 10, 20, 30, etc., the way it does when the minimum is set to 0. The maximum number of steps Numbers seems to allow is 10, but I need 11. Is there any way to increase the number of steps?

Information:
PowerBook G4
Mac OS X (10.5.7)

Posted: Jul 27, 2009

View 12 Replies!   View Related
Numbers 09 :: Multiple Text Lines Within Chart Title Or Axis Category?
I'm designing charts with lengthy titles and axis categories. The default title or axis setting in the chart inspector, when I select 'show title' or 'show categories', is 1 line of text. I'd like to format the title text box as if the text is wrapped within a taller and narrower text box.

I thought I knew of a way to divide a chart title (or axis category) into multiple lines of text. I can't seem to remember how I accomplished this. I realize I could make custom text boxes, but I'd like to avoid doing this for each category and title across multiple charts.

How can I format a chart title with 2 or 3 lines of text instead of the default 1?

Information:
iMac
Mac OS X (10.6.4)
3.06 GHz Intel Core 2 Duo

Posted: Dec 12, 2010

View 6 Replies!   View Related
Numbers 09 :: Bar Chart With Event Labels?
there is a way to make a bar chart that only has labels for specific data points instead of labeling every single data point.

Information:
imac 27
Mac OS X (10.6.4)

Posted: Nov 13, 2010

View 4 Replies!   View Related
Numbers 09 :: Chart / Columns Labels (Sum Of Series)
I am building a Column chart I'm not sure what its called but its where you add different series together to make a column chart (this option is second from the top and on the left side in the charts selector). I would call it a additive column chart. What I want to do is add a label to the chart. However, I don't want the labels of the individual series but the sum of the series. I would like this number to appear at the top of the Chart Column.

So for example if my data for a particular column says:
Canada 10
US 5
Other 3

I want the number 18 to be displayed in the chart. It is an additive column of course so why can't I show the total? I just want to show the total somehow as a number on the chart.

Information:
MacBook Pro
Mac OS X (10.5.8)

Posted: Aug 9, 2009

View 1 Replies!   View Related
Numbers 09 :: Chart Category Labels - Using Diagonal Instead Of Horizontal
I made a bar chart and the labels are longer. I would like to have them be diagonal instead of horizontal, which is the auto setting. Numbers seems to make every other one disappear, because otherwise they would write over each other. If they are at an angle, then you could see the whole label.

Information:
Mac OS X (10.6.4)

Posted: Nov 21, 2010

View 5 Replies!   View Related
Keynote 09 :: Impossible To Move Y-axis Value Labels Closer / Farther From Axis
first time trying to use keynote to prepare figures for publication, when I shrink graphs down to appropriate level, I noticed that it appears impossible to move the y-axis value labels closer/farther from the axis. I understand that moving the tick marks to the inside will move in the numbers slightly, but they are still much farther off than I want them. Any ideas?

Information:
iMac & macbook
Mac OS X (10.6.2)

Posted: Feb 24, 2010

View 5 Replies!   View Related
OS X Leopard :: Unable To Create Backup / Time Machine Goes To Backup Dates Filing System
I accidentally took Time Machine off the desktop top grey bar to the right (having a brain **** on its name right now)

When I open the program from the FInder, it goes to the backup dates filing system and wont backup.

Im just looking to get back the small window that lets you backup with just hitting one button.

Information:
Mac OS X (10.5.6)

Posted: Jan 4, 2009

View 2 Replies!   View Related
Numbers 09 :: Using 'rules' To Flag Dates
I have a cell with a date in it. I'd like to apply a conditional format to it so that if the date is say, one week away the cell turns orange; if it is three days away it turns red, and once the day has passed it turns grey. (Well something like that anyway!)I've had a play with the rules, but I can't get the cell to change colour at all!

Information:
Dual G5
Mac OS X (10.5.1)

Posted: Jan 16, 2011

View 1 Replies!   View Related
Numbers 09 :: Create Dynamic Range On The Y-Axis?
I am presenting 2 sets of data in a column graph.

Cash | Debt
83,457 | 715,397
106,457 | 585,741
84,856 | 442,392
184,294 | 296,254

I do not want to use dual Y-Axis, rather I would like the range (in 4 steps) on the Y-Axis to be:

0 - 50,000
50,000 - 150,000
150,000 - 500,000
500,000 - 1,000,000

Is there a way to create a dynamic range on the Y-Axis?

Information:
MacBook Pro 15
Mac OS X (10.6.1)

Posted: Oct 14, 2009

View 1 Replies!   View Related
Numbers 09 :: How To Create A Mixed Chart
What I need to do is to create a chart with two different types of data. On the left I want to show "body temperatures" and on the right, I want to show the amount of thyroid medicine consumed that day for that body temperature.

Information:
Mac Pro & MacBook
Mac OS X (10.5.6)

Posted: Apr 23, 2009

View 5 Replies!   View Related
Numbers 09 :: How To Create Ranking Chart
I need to create a ranking chart, like the one in the example: [URL]. I'm using Numbers 09 in english on an italian macbook.

Posted: Sep 27, 2009

View 1 Replies!   View Related
Numbers 09 :: Create Pie Chart - In Shape Of House?
I want to create a "pie chart", but I want it in the shape of a house. Basically, I want to have the outline of a house and as our sales goals increase, the house gets filled in with a particular color. Does anyone know if this is possible in Numbers?


Posted: Aug 19, 2009

View 14 Replies!   View Related
Numbers 09 :: How To Create A Chart By Combining 2 Charts From Other Sheets
I have two sheets with 2 charts. Column A of chart 1 (sheet 1) has several items; Item 1, Item 2, Item 3 and so on. Column B of that chart has numerical values for each item. The chart on sheet 2 is the same but with different values. Also it may have more items. Instead of just Item 1-3, it may have items 1-6, with corresponding numerical values. I want to create a chart on a "Totals" sheet that will total out all of my item 1's from sheet 1 and sheet 2, all my item 2's and so forth.

Information:
iMac CoreDuo
Mac OS X (10.5.8)

Posted: May 22, 2010

View 2 Replies!   View Related
Numbers 09 :: Can't Create Chart From Totals In Row Categories
My table has a about 50 vendors, and each vendor has 5 -20 individual salesmen. I did not create a header/total row for each vendor and instead, I opted to create categories, which collapsed the rows and gave me totals for each vendor.

The problem is that I had wanted Numbers to create a chart with the vendor totals to track how they are doing month to month, but the program doesn't allow me to click on the chart icon. The icon only becomes active if I expand each category and select individual rows.

Information:
MacBook Pro
Mac OS X (10.6.4)

Posted: Dec 1, 2010

View 5 Replies!   View Related
Applications :: Trying To Create Pie Chart (Based On MCQ) In Numbers
Got Numbers 08 installed, never really used it as didn't have a need. Created a spreadsheet the last day with some survey results for a project and saved it.

My spreadsheet looks like:
(A1-Grey) - Sex - Age - Multiple choice question
(Blank-Grey) - Male - 30 - Answer1
(Blank-Grey) - Female - 25 -Answer2

With a blank column on the left that's grey and the top heading thing being grey. Bit lost though with turning say the "Multiple choice question" column into a pie-chart (or any sort of chart tbh). I choose the header and all the 30 or so replies in that column and select chart -> pie-chart. It presents me with a pie-chart "Chart1" with just blue - 100% and the legend stating : blue - Untitled 1. How would I go about making the chart with the data I need? (I know I'm selecting it wrong or have it laid out wrong or something) or editing a chart manually.

Posted: Mar 1, 2009

View 3 Replies!   View Related
Numbers 09 :: Changing The X-axis Crossing Point On Log Y-axis
Is it possible to change the point at which the x-axis crossing a log y-axis? I'd like the origin to be 0.1, not 1, and I'm losing hours of my life trying to work out how to do it. Hopefully it will be something easy that I have missed... I'd rather look foolish than buy Microsoft office.

Information:
Macbook pro
Mac OS X (10.5.7)

Posted: Jun 17, 2009

View 8 Replies!   View Related
Pages 09 :: How To Merge A Document From Numbers To Create A Mailing Address Labels
anyone know how to merge a document from numbers to create a mailing address labels? i've tried several times... i either get a document with only one address on it or i get an entire page filled with the same address for each entry. help!:

Posted: Jan 21, 2010

View 7 Replies!   View Related
Numbers 09 :: Change Point Where Y-Axis Crosses X-Axis
How to change the point where Y-axis crosses X-Axis, for example, instead of crossing the zero crossing in the value 1?

Information:
MacBook 13
Mac OS X (10.6.3)

Posted: May 1, 2010

View 1 Replies!   View Related
Numbers 09 :: Making X-axis Intersect Y-axis At Zero
I think this is probably a simple question but couldn't find it answered anywhere. Basically I have some data I want to plot on a graph which has some of the 'y values' as negative. I have tried to make a scatter chart which works, but it puts the x-axis at the bottom, rather than it still intersecting the y-axis at zero which is what I want. Seems like it should be simple as I guess this is a common request but I couldn't work out how to do it.

Information:
iBook G4 1.33GHz (14" Display)
Mac OS X (10.5.6)

Posted: Mar 1, 2009

View 1 Replies!   View Related
OS X Leopard :: Creation Dates Are Wrong?
I'm having a lot of problems with my new iMac (6 weeks old), but let me start with the biggest problem.
Going through my Documents folder, each folder has the same date for Creation and Modification. Granted, each folder has different dates, but they are the same. The problem seems to only be with folders, as documents NOT put in folders show the correct dates.

Information:
iMac
Mac OS X (10.5.4)
2.4 Intel Core Processor, 1 GIgRAM

Posted: Feb 27, 2009

View 2 Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved