Chart - X Axis is Dates - I'd like to show months but still retain the weekly gridlines

M

MCCAFFREY

I have an x-y chart which plotes dates (Mondays) along the x axis and number
of widgets up the y axis. Currenly the x axis lables comprises of a date
for each ordinate. I'd like the x axis to show months only, but I'd still
like to retain all of the data points on my chart (i.e. weekly).

Can anyone advise me how to do that.

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reversing Dates Sequence along X axis in a chart 3
How to draw a graph with the X axis as a time line of date. 4
Dates, And Their Corresponding Numbers: How To Show ? 0
Condensing part of the X-Axis Excel 2007 charts 3
chart dates and times (excel 2007) 3
PowerPivot How to chart with contiguous time axis? 0
Excel 2007: X-axis labeling 1
Bar Chart With Custom Labels On X and Y? 0

Top