[Solved] Show chart but not data cells

[sracing]

New guy here to graphing. A couple of problems.

I have built a dynamometer data collection system. Works great as far as collecting the data and creating a .csv file. Example of the file in the spread sheet is here :

Code: Select all

RPM	TOR	HP	OP	A/F
3228	34.6	21.3	72	12.8
3263	39.7	24.7	70	13.0
3354	46.2	29.5	73	13.4
3595	50.6	34.6	72	13.9
3595	53.2	36.4	74	14.9
3686	59.9	42.1	74	14.9
3721	63.0	44.6	68	15.5
3801	65.2	47.2	68	15.7
3767	66.5	47.7	70	15.8
3721	67.2	47.6	71	16.0
3812	66.8	48.5	69	15.8
3870	65.9	48.5	79	16.3
4076	68.5	53.1	72	16.0
4225	67.7	54.5	76	15.9
4373	68.2	56.8	76	16.0
4476	69.6	59.3	68	16.2
4637	71.8	63.4	73	16.6
4717	75.6	67.9	71	16.9
4809	78.2	71.6	71	17.6
4854	80.0	73.9	73	17.2
4889	81.1	75.5	80	17.4
4934	83.1	78.1	73	17.5
4980	84.9	80.5	77	18.0
4992	84.3	80.1	81	18.0
4946	84.6	79.6	68	18.0
4843	79.4	73.2	73	17.2
4854	76.0	70.2	79	16.9
5060	75.5	72.8	66	16.7
5415	77.0	79.4	82	16.8
5770	77.7	85.3	79	17.1

I can line graph it all fine. My Y values are columns B, C, D, and E. (TOR, HP, OP, and A/F)
The X file is RPM.

Question #1. I just want to print the graph ONLY with the data points, NOT the full spread sheet. I can't see a way to do this.
Probably an easy answer. ?
Question #2. I would like to make the X axis with data points at eg. 3000, 3200, 3400, 3600, 3800, 4000, 4200, 4400, etc. I think this can be done by some form of extrapolation ?

I could change the data collected from the dyno but it is a bit more difficult due to timing and the nu,ber of samples taken / sec.

Any ideas? Thanks.
Jim

Edit: Changed subject, was "Smoothing" numbers for graphing dynamometer  Make your post understandable by others  -- MrProgrammer, forum moderator

[Zizi64]

Question #1. I just want to print the graph ONLY with the data points, NOT the full spread sheet. I can't see a way to do this.
Probably an easy answer. ?

Put the graph onto an empty sheet.

[MrProgrammer]

Hi, and welcome to the forum.

New guy here to graphing.

In OpenOffice this feature is called a chart. A graph is one type of chart, but Calc supports many other types of charts.. Forum searches will be more productive when you know the correct term.

I can line graph it all fine.

I think you will want an XY Scatter chart instead.

I just want to print the graph ONLY with the data points, NOT the full spread sheet.

Use Insert → Chart on the sheet with the data. This always puts the chart on that sheet. Create a new sheet with Insert → Sheet. Copy the chart to the new sheet using the Navigator as explained in the topic below. Do not use copy/paste or cut/paste to put the chart on the new sheet. Use the Navigator with drag mode Insert as Copy. Print the new sheet which contains only the chart. You can delete the first chart on the sheet with the data if you want.
[Solved] XY charts not updated when data changes

I would like to make the X axis with data points at eg. 3000, 3200, 3400, 3600, 3800, 4000, 4200, 4400, etc.

Format the chart's X-axis and set the Major Interval to 200. Read details about working with charts in this important document.
Calc Guide Chapter 3: Creating Charts and Graphs

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know