numbers
I'm new to Numbers and now creating my first chart. I tried to find what I was looking for on google but couldn't find anything. What I would like to do is change the numbers in the Y axis to show has custom letters or words instead of numbers while still keeping their values, if that makes sense. For example:
Would that be possible?
Thank you for any help.
To save on the cramming part of the Chart you could try using an interactive Chart with a scroll bar.
1, Start a new sheet and fill it with your data:
2, Go to the Chart menu and select Interactive Chart & the style you want.
I have chosen the simplest. Others you may have to play more with.
3, Click the Chart and then it's Add Chart Data button.
4, select either rows by clicking on each day of week row.
4.1 Or Columns by clicking on the WEEK columns
5, Click the DONE button at the bottom of the page when you have completed your selection.
If you need to remove/add a column or row from the Chart data. Then Click the Chart. And then the Edit Chart Data button.
Adding is the same as you did before.
Removing is clicking on the row or column and hitting the delete/backspace key. this does not remove the eta from the sheet only from the chart.
The chart I chose has a scroll bar which you can scroll through.
You can change the text size by using the format palettes.
And you can add labels to the Chart columns
by using
If I figure how to make it pick up the sheet info by it's self I will update.
To answer the first part of your question, please see this Answer to Force line chart to show axis at point (0, 0)
Second part:
Select the line to highlight it. Then under Style in the Inspector the Connection Line and weight can be adjusted by point.
Best Answer
This admittedly is a bit of a hack but I can't find another solution that works in Numbers.
One way to make letters appear over the numeric values is to position textboxes with the letters over the values to block out the numbers below them. Just click the Text button in the toolbar, drag the textbox to the correct position, size it appropriately and set it to have a white fill colour and no border.