Re: Formatting X Axis

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

The scale is being plotted as a date scale, due to the labels being dates, instead of Categories which is what you want.
Right click chart and pick Chart Options. On the axes tab set the X axis to be Category instead of Automatic.

Cheers
Andy

sony654 wrote:
I am building a simple line chart that "charts" stock prices by date. For example the data series of prices is cell c2:g2, then I am selecting the x-axis labels which are in cells c7:g7. Problem is, more than 5 date labels are displayed on my x-axis. For example, only 09/18/07, 09/21/07, 09/23/07, 09/25/07, 09/27/07 are the true x-axis labels that should correspond to my data series, BUT, dates such as 09/20/07, 09/22/07, etc. are displayed as x-axis labels. How do I only display the x axis labels that pertain to my selected data series. I must not be scaling the x axis properly. Thanks if you can help. Sony
.

Relevant Pages

  • Re: Chart a time series
    ... How do I chart a time series (a series of dates with a value associated with ... The dates are not evenly spaced, and I would like the axis to be ... I suggest instead that you create a special data series with nothing but zeroes. ... Display that data series, then choose Data Labels.. ...
    (microsoft.public.excel.charting)
  • Re: XL Axis label formatting issue
    ... Then select the whole range and chart it. ... Then Double click the data series and change check the Category Name on the ... DataLabels tab. ... Then right-click the data labels and on the Alignment tab, ...
    (microsoft.public.excel.charting)
  • Re: align labels on X axis
    ... Perhaps the Time is if it is a Scatter chart, ... Under this same Category X axis scale label I have: ... I want annual labels, although the data is in quarters. ...
    (microsoft.public.excel.charting)
  • Re: Newbie question/thanks
    ... i think they should rename it a ''chart' EDSC cause it aint no scale ... its a chart,,,its not a graph,, its a chart,,, maybe even not that high on ... whatever one you go by,, they are just labels,,, and i dont label,,, ... FYI folks if they dont consider MS a fatal disease why the number 10??? ...
    (alt.support.mult-sclerosis)
  • Re: swapping axis
    ... Right-click on the data series you want to move to the 2nd y axis. ... If the data you selected had header text (labels) at the top of each ... then those labels would show up on the chart. ...
    (microsoft.public.excel.charting)