Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

xl charts

ResolvedVersion 2003

Jelena has attended:
Excel Introduction course

Xl charts

How do I change the scale of the values in my chart

RE: xl charts

Hello Jelena

Thank you for your question and welcome to the forum.

Once you have created a chart in Excel, you can adjust the scale on the vertical axis of the chart by double-clicking anywhere along the axis, then selecting the Scale tab.

Here you can change the interval/gap between the tick marks on the axis using the Major Unit box.

I hope this helps.
Amanda

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.