How do I graph data daily as a line graph across a calendar format
 

--
glani

How do I graph data daily as a line graph across a calendar format
 

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

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

How do I graph data daily as a line graph across a calendar fo
 

Hi,

It's possible but not a built-in option.
You need to build a variation of a Panel chart
http://peltiertech.com/Excel/Comment...DayOfYear.html

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.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Glani" wrote in message
...
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