Page 1 of 1

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

PostPosted: Mon Dec 03, 2018 3:57 am
by tawnirux
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.

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

PostPosted: Mon Dec 03, 2018 5:16 am
by FJCC
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.

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

PostPosted: Mon Dec 03, 2018 10:46 pm
by jrkrideau
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.