## Excel 2010 Chart with Log Scales

## Excel 2010 Chart with Log Scales

(OP)

Hi,

I'm charting my data, and in order to get a straight line regression on it, I'm using Logarithmic X and Y axes, then putting a Power trendline on it.

It all works just fine, but the data tends to be all bunched between one or two gridlines on the axis. For instance, X-values between 20,000 and 30,000 units. That gives me 2 'Minor' gridlines on the chart, one at each end, and no intermediate lines. Is there a way I can specify a finer gridline spacing, say at 100's?

I've fudged it before with a dummy 'axis'series and error bars with "X-Y Chart Labeller", but I'm too idle to set that up every time.

I'm charting my data, and in order to get a straight line regression on it, I'm using Logarithmic X and Y axes, then putting a Power trendline on it.

It all works just fine, but the data tends to be all bunched between one or two gridlines on the axis. For instance, X-values between 20,000 and 30,000 units. That gives me 2 'Minor' gridlines on the chart, one at each end, and no intermediate lines. Is there a way I can specify a finer gridline spacing, say at 100's?

I've fudged it before with a dummy 'axis'series and error bars with "X-Y Chart Labeller", but I'm too idle to set that up every time.

Chris

**Someday I'll know what I'm donig...damn!
**

## RE: Excel 2010 Chart with Log Scales

Some data might help.

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Excel 2010 Chart with Log Scales

Solid Linerather than Automatic for theMinor Gridlines.???

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Excel 2010 Chart with Log Scales

Try This with Hours on the X and Count on the Y. Making this a Log-scale chart gives a near-vertical line between the 20000 and 30000 gridlines. I'd like those to be the Min and Max of the X-Axis, with 1000-hour minor gridlines between them.

Hours Count

20241 64

20241 65

20666 66

20666 67

20666 68

20666 69

20666 70

20982 71

20982 72

20982 73

21499 74

21499 75

21499 76

21499 77

21499 78

21839 79

22071 80

22233 81

22612 82

23127 83

23127 84

23127 85

23127 86

23127 87

23345 88

24338 89

24338 90

24559 91

24559 92

24909 93

25131 94

25131 95

Chris

Someday I'll know what I'm donig...damn!

## RE: Excel 2010 Chart with Log Scales

This is No Log, Minor Gridlines !000.

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Excel 2010 Chart with Log Scales

It's just that the data set is inconveniently place between widely-spaced logarithmic gridlines. If I define the Max/Mins of both axes to be 20000-30000 on the X, and 50-100 on the Y axis, ther are no Minor gridliines visible. This makes it difficult to extrapolate or interpolate the data visually, as with graph paper.

I can fake the gridlines with dummy series with their error bars named using X-Y Chart Labeller, but isn't there a more built-in way of doing this?

See the attached chart for an example.

Chris

Someday I'll know what I'm donig...damn!

## RE: Excel 2010 Chart with Log Scales

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Excel 2010 Chart with Log Scales

Chris

Someday I'll know what I'm donig...damn!

## RE: Excel 2010 Chart with Log Scales

Chris

Someday I'll know what I'm donig...damn!

## RE: Excel 2010 Chart with Log Scales

combo

## RE: Excel 2010 Chart with Log Scales

comboThat's the reminder I needed! No need for XY Chart Labeller (fantastic though it is)Chris

Someday I'll know what I'm donig...damn!

## RE: Excel 2010 Chart with Log Scales

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Excel 2010 Chart with Log Scales

combo