# help me make this excel graph

**URL:** <https://boards.straightdope.com/t/help-me-make-this-excel-graph/277244>\
**Category:** Factual Questions\
**Created:** [November 30, 2004, 12:21am UTC](https://boards.straightdope.com/t/help-me-make-this-excel-graph/277244 "2004-11-30T00:21:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![saluki\_fan](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@saluki\_fan](https://boards.straightdope.com/u/saluki_fan)\
**Post date:** [November 30, 2004, 12:21am UTC](https://boards.straightdope.com/t/help-me-make-this-excel-graph/277244/1 "2004-11-30T00:21:09Z")

</div>

OK - so can somebody tell me how to create a graph where the x axis reads 1,2,3,etc and the y axis is in values of 10s? Also, how can I put a value of 1,58 and 9, 53 on the same excel graph? Thanks.

---

<div class="post-metadata">

**Author:** ![saluki\_fan](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@saluki\_fan](https://boards.straightdope.com/u/saluki_fan)\
**Post date:** [November 30, 2004, 12:49am UTC](https://boards.straightdope.com/t/help-me-make-this-excel-graph/277244/2 "2004-11-30T00:49:03Z")

</div>

ok, I’ve figured out how to get the x and y axis, but I can’t figure out how to get 58 and 53 without changing the y axis values to 50-59.

---

<div class="post-metadata">

**Author:** ![Enright3](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/enright3/32/2897_2.png) [@Enright3](https://boards.straightdope.com/u/Enright3)\
**Post date:** [November 30, 2004, 4:12am UTC](https://boards.straightdope.com/t/help-me-make-this-excel-graph/277244/3 "2004-11-30T04:12:25Z")

</div>

Put your source data for the x axis in one column, right next to that put your Y values in another column.  
i.e.

```auto

X Values | Y Values
    1 58
    4 56
    7 54
    9 53

```

Select the data, click on graph,  
Build your graph, then right click on the axis and select **Format Axis**.  
From there click on **Scale**.

From there you can override the auto features that set the scale.  
Uncheck **Minimum** and type in 0  
Uncheck **Major Unit** and type in 10.  
(Removing the checkmark turns off the auto feature)

If you need more detailed help let me know.

E3