When selecting the range for your chart, hold down <SHIFT>. That way you can select mutiple non-adjacent lines.1. I want to create a chart in my spreadsheet that uses columns a and c. How do I not use adjacent columns? It is a simple x,y line chart.
You can also do this by hand. Assuming there are four rows on columns a and c, you select them with $Sheet1.$A$1:$A$4;$Sheet1.$C$1:$C$4
After creating the chart, right-click on it, select Edit.2. I want to not start at 0 on the y axis.
Right-Click again, select Axis -> Y-Axis. On Scale leaf you can find selection Axis at. Change that to whatever you need.
You have to change the column display format for that.3. Column a contains dates and I only want the day of the week in my chart.
Select the column, choose Format -> Cells. In Numbers leaf there are lots of different formats. Choose Date, change format code to NNNN. That should do the trick.
-- Maailmassa eniten tuhoa aikaan saanut kemikaali on testosteroni. The most destructive chemical in the world has been testosterone. - Mixu Lauronen
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
