--
glani

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" <(E-Mail Removed)> wrote in message
news:A85AF2CE-0F71-4028-ADD7-(E-Mail Removed)...
>
> --
> glani

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" <(E-Mail Removed)> wrote in message
> news:A85AF2CE-0F71-4028-ADD7-(E-Mail Removed)...
> >
> > --
> > glani
>
>
>

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" <(E-Mail Removed)> wrote in message
news:F20CD0DC-6D41-4BD2-BB74-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:A85AF2CE-0F71-4028-ADD7-(E-Mail Removed)...
>> >
>> > --
>> > glani
>>
>>
>>