Excel 2007 : Dynamic Charting Discontinuous Timeline

[sriniyer]

Hi,

I am trying to plot a time data with discontinuous time line for a dynamic chart.

Example:
Date Value
1/1 10
1/3 15
1/4 16
1/7 20 etc.

Upon creating the chart I see gaps for the dates for which values are not given. Remember there is no row for these dates at all. I would like to know how to remove gaps from my chart for these dates.

SI

[jeffreybrown]

Hello sriniyer and Welcome to the Board,

After you create the chart

1. Right click on the Horizontal (Category) Axis
2. Format Axis
3. Axis Type: Check Text axis
4. Close

Now you should be left with a chart that has all the gaps removed.