Imported from the Apple Support Forums via the Wayback Machine 🔗
Appleworks 6. In a spreadsheet, I have two sets of data, eg 3 5 5 4 8 7 9 6 where I want to show the first column along the X axis in time and the second column as values, eg.
Choosing Axes and select X axis and setting min and max, the graph will invariable show my desired X values equidistant along the axis and not spaced along the axis. Instead it always shows them as Y values. Setting Y responds. Setting X does nothing.
Is the only solution to create null spaces in my data to fake the temporal separation I seek along the inflexible X axis? If it was just the above example I wouldn't mind doing this, but the time data actually stretches over 4 years.
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi roam,
If I'm reading the last line right, you have a single set of data pairs that track an unspecified variable (the second column) over time, not "two sets of data". Showing paired data requires an X-Y graph. Adding a connecting line between data points makes it easier to see a trend if one of the variables is Time.
Try this:
Enter the sample data from your post into a spreadsheet. Select the data block. Press command-M In the Gallery, select X-Y line as the graph type. Click Axes. Y axis: Enter "Value" as the axis label and 0 and 10 as the Min and Max values. Ignore other settings. X axis: Enter "Time" as the axis label and 0 and 10 as the Min and Max values. Ignore other settings. Click OK.
Regards, Barry
0
Apple Support Community member·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Thank you very much Barry, that's perfect.
0
Apple Support Community member·
Imported from the Apple Support Forums via the Wayback Machine 🔗
You're welcome, roam.
Thanks for marking this question "answered" and thanks for the star.