Line chart showing final value only?

I'm not sure that I understand what you really wish.

I may build these charts:



Yvan KOENIG (from FRANCE vendredi 15 mai 2009 13:57:08)

I'm not sure I understand your request either. I am assuming you are talking about the values listed on the X axis of a chart. If your chart is anything other than a scatter chart, the values (labels) are taken from the header column. So it's pretty easy to figure out what to do: put a space in the header of all but the last row of data. However, it appears that you are talking about a scatter chart (though I must assume you made those numbers up and did not get them from the X axis of your chart). If you are not displaying the vertical gridlines (the default when Numbers makes the chart), you can go to the Axis tab of the Chart Inspector and do the following :

1. Set the X axis steps to 1
2. Click on the X Axis options and uncheck "show minimum value"

If, on the other hand, you are talking about the value labels as in "show value labels" and are not referring to the X axis at all, you do the following: On the Series tab of the Chart Inspector, you would have "show value labels" checked. Make a custom format for those values so that if the value is "less than 74", it displays nothing.

I can give a few other ideas but I guess I'll wait until I figure out exactly what it is you're looking to do

Message was edited by: Badunit

To post an image on the forums you have to upload it to a site where it can be shared. Flickr, ImageShack, Photobucket, a MobileMe account, or other. Then you put it in your post as:

img src="Insert URL Here" enclosed between the less than and greater than symbols.

http://discussions.apple.com/thread.jspa?messageID=8758780&#8758780

Message was edited by: Badunit

Tumble,

To me the most straight-forward solution is to create a little 1-cell table to display the last value and to place that table wherever you wish when you review your chart prior to publication.

Here's an example:

The expression in the table cell that displays the last value is: =OFFSET(Data Table :: B1,COUNT(Data Table :: B),0)

If you add data by using the Add Row command, the chart range will automatically expand to include the new data and the Last Data Value cell will auto-update. The only thing left for you to do is slide the data value table up or down to match the height of the last value plotted.

Jerry

+You say 'if you add data by using the 'add row' command, but I just have a table that is bigger than I need and add new data in the next rown down (a sloppy way to do it I know). WOuld your solution work with this, eg does OFFSET / COUNT count up to the last row without data in it or is it just looking at the last actual row so if I have 1,000 rows with data in the first 50 it will just go to row 1,000?+

It's just a personal preference of mine to enlarge the table only as needed. That way I don't have to scroll down to see calculations that may be in a Footer Row. Did you know that to add a Row to a Table, all you have to do is click on the handle just below the last row's label? Clicking once adds one row.

Either way will work if you apply the formula I suggested. COUNT looks at the range you have given it and counts the number of cells that contain data, ignoring the Header and Footer cells.

Jerry

+I"m not finding the manuals much help (and the help is even less helpful+

If you don't at least skim the User Guides to see what's there, you're missing the boat. They aren't difficult to read through and will give you the overall picture of what can be done. Then if you watch some tutorials on the Apple site, going back to the User Guides to confirm what you saw in the videos, you will begin to appreciate the wealth of information in the guides. To polish your skills, keep an eye on these discussions and see if you can guess or figure out the answers to questions posed by those close to your experience level.

Jerry