# How to prevent a large scatter graph being squashed?

#### jj-007

##### New Member
Hi I am trying to plot a scattered line graph that contains nearly 4000 points on the y axis. The points represent a day. The x axis is the percentage belonging to that day. The problem that I am having is that the graph looks squashed together and the line is very thick because of this. One of the reasons for this is that a lot of the 4000 points have similar percentages so the line just moves a tiny bit. Is there a way that I can make the graph look more presentable? Thanks

The following is a picture of how it looks. You may need to enlarge it to see it properly.

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

• Plot every nth data point
• Or do a running average (or min or max) of n data points

• Plot every nth data point
• Or do a running average (or min or max) of n data points

I need to be able to see where the line peaks. So if I plot every nth point, wouldnt that show incomplete results?

I need to be able to see where the line peaks. So if I plot every nth point, wouldnt that show incomplete results?

A running Max will preserve peaks.

Alternatively, widen your chart... a lot.

A running Max will preserve peaks.

Alternatively, widen your chart... a lot.

How would I do a running max?

This will return the max value for every block of four values in column A (x-axis data) starting at A1. Put it at the top of an empty column and drag down. Do the same for column B (y-axis data). Adjust the 4s within the formula to change the sub-sample rate.

=MAX(OFFSET(A\$1,ROW(A1)*4-4,0,4))

Replies
1
Views
239
Replies
3
Views
1K
Replies
1
Views
953
Replies
6
Views
773
Replies
0
Views
620

1,206,817
Messages
6,075,041
Members
446,114
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back