Line graph: Format x axis/grid to display ~10 out of 10k pts

Discuss the spreadsheet application

Line graph: Format x axis/grid to display ~10 out of 10k pts

Postby tawnirux » Mon Dec 03, 2018 3:57 am

I created a line graph from approximately 10,000 x-y data points. I need to format the x axis/grid similarly to the y axis to show how the data progresses. The only options available are to include all data points along the x axis, or create a grid that does the same.

The only suggestions I have found here include using the xy scatter chart type instead of a line graph, but I'm not sure how to make a single line/curve with both x-y points using that chart type. Another suggestion is to use open office drawing to edit the axis instead but there was no clear way to do that either.

Any help you can offered would be greatly appreciated.
mac os high sierra 10.13.3
openoffice 4.1.5
tawnirux
 
Posts: 1
Joined: Mon Dec 03, 2018 2:56 am

Re: Line graph: Format x axis/grid to display ~10 out of 10k

Postby FJCC » Mon Dec 03, 2018 5:16 am

If you already have the x axis set up with the desired data as the labels of a line chart, you can make it an xy scatter plot by double clicking on the chart to put it in edit mode, then right click, select Chart Type and choose xy scatter.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7065
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Line graph: Format x axis/grid to display ~10 out of 10k

Postby jrkrideau » Mon Dec 03, 2018 10:46 pm

I need to format the x axis/grid similarly to the y axis to show how the data progresses.


What exactly do you mean by this? Is the x-axis continuous data or discrete, that is, non-numeric?

FJCC's suggestion is probably what you want.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3667
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: Exabot [Bot], Smith512 and 30 guests