View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Glani Glani is offline
external usenet poster
 
Posts: 2
Default How do I graph data daily as a line graph across a calendar fo

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.
--
glani


"Jon Peltier" wrote:

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.

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


"Glani" wrote in message
...

--
glani