Here is is my graph:
Here is my table:
Here is my problem:
I want the values across the x axis to read F 1 2 3 4 5 6 7 8 9
I want the graph and table to work exactly as is with just this change to the x axis. I also want minor gridlines (0.5 increments) without any labels but starting at 0.5 before 'F'.
Is this possible? How? Please help.
MacBook Pro
Mick,
Insert a Text Box and place an "F" in it. Grab one of the corners and make the box as small as possible without cutting off any part of the letter, and move the letter over the zero on the Value Axis. With the Text Box still Selected, go to the Format Bar, Fill rectangle color patch and click the patch. Choose a White Fill. This should obscure the zero and show the F.
Jerry
An automated way would be to use a custom format for the axis. Start at the Chart tab of the Inspector. Choose Custom for the X axis format then create a format that displays an F when the value is zero.
Badunit,
That's a great idea!
Jerry
Belated thank you, Badunit
Custom format of axis on charts - Help please.
