Zoom In Excel How To Work It

Instead of having a Series Values of A1:A235, make it A22:A57 or something similar.

In short, just chart the data you want rather than charting everything and trying to hide parts of it.

Select the vertical error bars and press Ctrl1 (numeral one) to format them.

Choose the Minus direction, no end caps, and percentage, entering 100 as the percentage to show.

This kind of x-axis is based on a count, i.e.

Ex. If you want to plot columns 5 through 36, set 5 as the x-axis minimum, and 36 as the x-axis maximum.

Do not enter a date for the kind of scaling youre trying to do here.) This is the only way I know of to rescale the unscalable axis.

MinXAxis Application.InputBox(Prompt:Enter Minimum Date (MMDDYYYY), Minimum Number, or Select Cell, Type:1).

The Min and Max of the first column are given in E1 and E2, along with the initial chart of the data.

On the Formulas tab of the Ribbon, click Define Name, enter the name counts, give it a scope of the active worksheet (I kept the default name Sheet1), and enter this formula.

Under Horizontal (Category) Axis Labels, click Edit, and change.

You can play with those settings to give you the results you prefer.

Is there more information you can provide about configuring it to produce the desired results.

Then change back to a graph you desire, and it will keep the axis settings adjusted.

When you change back from a scatter chart to a column chart, the column chart category axis is reinstated, without any mechanism for changing axis limits.

Zoom In Excel How To Work It

Excel is nothing if not flexible, if you know how to work it.

If Excel applies a date format to the axis labels, change back to a numeric format.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged microsoft-excel microsoft-excel-2007 charts or ask your own question.

How To Zoom In Excel For Mac