Thread: How do I show a bigger gap between non equadistant dates in Excel

I am so frustrated! I am trying to enter data that has 3 different dates not
equally distant and want to show on the associated chart that there is a
bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month). Can
anyone please help.

If you have a BAR chart, I'd suggest this. Let's say you have data for
1/05, 3/05 and 8/05. Why not have X labels for 1/05, 2/05, 3/05, 4/05, ...
8/05, but only enter Y values for the months of interest.

If you have a LINE chart, why not change it to XY Scatter.

"Grace Poole" <Grace Poole@discussions.microsoft.com> wrote in message
news:29E6DEB1-A4A7-47A9-A695-F07FC4B8CEBE@microsoft.com...
>I am so frustrated! I am trying to enter data that has 3 different dates
>not
> equally distant and want to show on the associated chart that there is a
> bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month).
> Can
> anyone please help.

Convert the x-axis to a 'time scale.' Select the chart, then select
Chart | Chart Options... | Axes tab. In there, set the Category (X)
axis to 'Time-scale'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <29E6DEB1-A4A7-47A9-A695-F07FC4B8CEBE@microsoft.com>, "=?
Utf-8?B?R3JhY2UgUG9vbGU=?=" <Grace Poole@discussions.microsoft.com>
says...
> I am so frustrated! I am trying to enter data that has 3 different dates not
> equally distant and want to show on the associated chart that there is a
> bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month). Can
> anyone please help.
>

Make sure that the values are interpreted by Excel as numerical dates, and
not just labels. Normally if Excel recognizes dates in the category range,
it will automatically select the time scale axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
news:MPG.1e37f4335be71a6b98b2e6@msnews.microsoft.com...
> Convert the x-axis to a 'time scale.' Select the chart, then select
> Chart | Chart Options... | Axes tab. In there, set the Category (X)
> axis to 'Time-scale'.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <29E6DEB1-A4A7-47A9-A695-F07FC4B8CEBE@microsoft.com>, "=?
> Utf-8?B?R3JhY2UgUG9vbGU=?=" <Grace Poole@discussions.microsoft.com>
> says...
>> I am so frustrated! I am trying to enter data that has 3 different dates
>> not
>> equally distant and want to show on the associated chart that there is a
>> bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month).
>> Can
>> anyone please help.
>>