You mean with dates along the X axis? Make sure the dates are really dates,
and not just text labels that look like dates. Make a line chart. Go to
Chart menu > Chart Options > Axes tab, and check the Time Scale option under
Category (X) Axis.
Thank you. I can make a line graph but I need to graph each day across a
calendar type format. Like if you opened up Outlook and chose to view the
calendar by month then you would see a months worth of data graphed across
each day. That's what I'm trying to achieve but using just Excel. I'm not
even sure it can be done in Excel.
Basically each days data needs to be plotted as a line. The values used need
to be altered in order for the line to appear in specific cell of the panel
that reflects the date of the data set.
