Bar Chart with Date X-Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am charting weekly sales totals for a list of products. The data is in a
table with the products in the A column and week-ending dates (formatted as
dates) in Row 1. The table uses a formula that references the dates in row 1
to find the data in other parts of the workbook. When I make the chart,
using row 1 and the X-range, Excell sees date missing and puts gaps between
my data. (the dates are 7-11, 7-18, 7-25 etc.)

Is there a way to avoid this? I know I can do it by formatting the dates as
text, but then my lookup formula won't work.
TIA
Marcotte
 
Marcotte -

Select the chart, and choose Chart Options from the Chart menu. Change
the Category Axis from Automatic to Category.

Excel recognized the dates, and made the axis a time scale axis. The
date spacing was days, since you had more than one value per month.
Excel then leaves a space for each day, so your data columns had to be
thin enough to fit in one day's gap, even though 6 of the seven days had
no data. In the category axis, each reported date is its own category,
with non in between.

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