Excel Scatter Chart - Elimintate Left-Hand White Space

[MattGreer]

Whenever I make a chart in Excel, for some reason, it's putting this extra white space on the left side of the x-axis. It reduces the amount of available space for the graph when viewed on the screen and/or printed.

The x-axis is a date, and may change, so "hard-coding" in the range of the x-axis DOES NOT WORK, unfortunately.

I want the x-axis to start on the date of the first data point, not before, not after.

Any ideas??

Thanks!!


Matt

 

[SkipVought]

Hi,

Are you referring to the the MIN Scale Value of the x-axis being much less than the minimum date value? You will have to change that MIN Scale value, eithre manually or via VBA code forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MattGreer]

Yes. The problem is that if the x-axis changes the date, the min scale value has to be changed manually.

Say I make a graph from yesterday to today. I can manually set the x-axis min value so that the graph actually "starts" at the first data point. If I change the graph, I must manually change the date again so that the graph appears appropriately. If I delete the graph and create a new one, I've got that annoying gap so I have to manually set it again.

I guess I don't understand where this arbitrary gap comes from, and why it is we can't set a "size" for the graph and have it exist like that no matter what the date is.

Considering that the data takes place over a course of hours, and evenly spaced at 30 seconds per data point, perhaps a line chart would be more appropriate?

Thanks!!


Matt

 

[SkipVought]

For charts that do not have a category x-axis, rather numeric of some flavor, Excel calculates a buffer at both ends where the limits and major scale incriments are sort of coordinated. Normally for positive numbers, the MIN Scale value is ZERO.

If you want the MIN Scale value to be the MIN data value, then post in forum707 for a solution.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}