Help. I am creating a chart that shows quantity (in whole numbers) for
several different data sets per week in columns. The x axis is supposed to
be in weekly intervals. If I do not include the cells with the weeks listed
in my x axis labels field in the "Source Data", my columns look great - nice
and wide, easy to see. Once I select my cells with my dates in them, the
columns get very skinny. I tried changing the gap and the overlap, with no
success. Help! How can I get my columns to look nice and wide, and still
have my weeks listed in my x axis??

The time scale axis has no Weeks setting. If Excel recognizes your dates as
dates, it will use Days instead, so for each weekly data point you will have
one column and six spaces, hence your thin columns. Change the time scale
axis to a regular category axis by going to Chart menu Chart Options
Axes, and selecting Category under Category (X) Axis.

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


"Hoosierquilt" wrote in message
...
Help. I am creating a chart that shows quantity (in whole numbers) for
several different data sets per week in columns. The x axis is supposed
to
be in weekly intervals. If I do not include the cells with the weeks
listed
in my x axis labels field in the "Source Data", my columns look great -
nice
and wide, easy to see. Once I select my cells with my dates in them, the
columns get very skinny. I tried changing the gap and the overlap, with
no
success. Help! How can I get my columns to look nice and wide, and still
have my weeks listed in my x axis??

BRILLIANT. That did it, Jon, egads, why didn't **I** think of that. I chose
all the other selections. Who would of guessed it (not me). Okay, another
question on the same damned chart: I am trying to plot some differing data
(ergo, a secondary axis, that much I know). My first data points as I
mentioned are whole numbers (I run a call center, and I'm looking at total
incoming calls, total outbound calls, and Ave. answer time in seconds). So,
the third data set is in seconds, not whole numbers. I've got my secondary Y
axis selected, chosen a line graph, set the secondary y axis in seconds, and
I've captured all my weeks worth of ave. answer times in seconds over the
weeks, but all the data points read as zero. The nice little pink line is
laying flat on the x axis. When I float my mouse over the data points, they
all read as zero. How do I get my nice little line to follow the secondary y
axis on the right side of the chart?

"Jon Peltier" wrote:

The time scale axis has no Weeks setting. If Excel recognizes your dates as
dates, it will use Days instead, so for each weekly data point you will have
one column and six spaces, hence your thin columns. Change the time scale
axis to a regular category axis by going to Chart menu Chart Options
Axes, and selecting Category under Category (X) Axis.

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


"Hoosierquilt" wrote in message
...
Help. I am creating a chart that shows quantity (in whole numbers) for
several different data sets per week in columns. The x axis is supposed
to
be in weekly intervals. If I do not include the cells with the weeks
listed
in my x axis labels field in the "Source Data", my columns look great -
nice
and wide, easy to see. Once I select my cells with my dates in them, the
columns get very skinny. I tried changing the gap and the overlap, with
no
success. Help! How can I get my columns to look nice and wide, and still
have my weeks listed in my x axis??

These points read zero, but they're not zero?

To get a series onto secondary axes (and to add secondary axes if they
aren't yet present) you double click the series, and on the Axis tab, choose
Secondary.

How are your seconds defined in the worksheet? Are they times, formatted
something like hh:mm:ss or mm:ss or [s]? Your secondary axis should be
formatted the same. If the axis is formatted as whole numbers, the seconds
would appear as zeros, since one second is 0.000011574 days (i.e., 86,400
seconds per day).

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


"Hoosierquilt" wrote in message
...
BRILLIANT. That did it, Jon, egads, why didn't **I** think of that. I
chose
all the other selections. Who would of guessed it (not me). Okay,
another
question on the same damned chart: I am trying to plot some differing
data
(ergo, a secondary axis, that much I know). My first data points as I
mentioned are whole numbers (I run a call center, and I'm looking at total
incoming calls, total outbound calls, and Ave. answer time in seconds).
So,
the third data set is in seconds, not whole numbers. I've got my
secondary Y
axis selected, chosen a line graph, set the secondary y axis in seconds,
and
I've captured all my weeks worth of ave. answer times in seconds over the
weeks, but all the data points read as zero. The nice little pink line is
laying flat on the x axis. When I float my mouse over the data points,
they
all read as zero. How do I get my nice little line to follow the
secondary y
axis on the right side of the chart?

"Jon Peltier" wrote:

The time scale axis has no Weeks setting. If Excel recognizes your dates
as
dates, it will use Days instead, so for each weekly data point you will
have
one column and six spaces, hence your thin columns. Change the time scale
axis to a regular category axis by going to Chart menu Chart Options
Axes, and selecting Category under Category (X) Axis.

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


"Hoosierquilt" wrote in message
...
Help. I am creating a chart that shows quantity (in whole numbers) for
several different data sets per week in columns. The x axis is
supposed
to
be in weekly intervals. If I do not include the cells with the weeks
listed
in my x axis labels field in the "Source Data", my columns look great -
nice
and wide, easy to see. Once I select my cells with my dates in them,
the
columns get very skinny. I tried changing the gap and the overlap,
with
no
success. Help! How can I get my columns to look nice and wide, and
still
have my weeks listed in my x axis??

That's correct, the values are in seconds, such as :02, :03, :04, etc. up to
about :08 seconds (we're quick to answer our phones).

I have the secondary axis checked, and my seconds are defined as time in
seconds in the cells (Time=13:30:55). The problem is in defining the
secondary axis in seconds. When I open up the "Format Axis" box, the values
in the "Scale" tab are numeric. I have the "Number" tab set to Time (13:30
or 13:30:55, it doesn't seem to make a difference), but it's the "Scale" tab
that defines the increments, and that's a number, not a time value. Any other
suggestions??

"Jon Peltier" wrote:

These points read zero, but they're not zero?

To get a series onto secondary axes (and to add secondary axes if they
aren't yet present) you double click the series, and on the Axis tab, choose
Secondary.

How are your seconds defined in the worksheet? Are they times, formatted
something like hh:mm:ss or mm:ss or [s]? Your secondary axis should be
formatted the same. If the axis is formatted as whole numbers, the seconds
would appear as zeros, since one second is 0.000011574 days (i.e., 86,400
seconds per day).

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


"Hoosierquilt" wrote in message
...
BRILLIANT. That did it, Jon, egads, why didn't **I** think of that. I
chose
all the other selections. Who would of guessed it (not me). Okay,
another
question on the same damned chart: I am trying to plot some differing
data
(ergo, a secondary axis, that much I know). My first data points as I
mentioned are whole numbers (I run a call center, and I'm looking at total
incoming calls, total outbound calls, and Ave. answer time in seconds).
So,
the third data set is in seconds, not whole numbers. I've got my
secondary Y
axis selected, chosen a line graph, set the secondary y axis in seconds,
and
I've captured all my weeks worth of ave. answer times in seconds over the
weeks, but all the data points read as zero. The nice little pink line is
laying flat on the x axis. When I float my mouse over the data points,
they
all read as zero. How do I get my nice little line to follow the
secondary y
axis on the right side of the chart?

"Jon Peltier" wrote:

The time scale axis has no Weeks setting. If Excel recognizes your dates
as
dates, it will use Days instead, so for each weekly data point you will
have
one column and six spaces, hence your thin columns. Change the time scale
axis to a regular category axis by going to Chart menu Chart Options
Axes, and selecting Category under Category (X) Axis.

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


"Hoosierquilt" wrote in message
...
Help. I am creating a chart that shows quantity (in whole numbers) for
several different data sets per week in columns. The x axis is
supposed
to
be in weekly intervals. If I do not include the cells with the weeks
listed
in my x axis labels field in the "Source Data", my columns look great -
nice
and wide, easy to see. Once I select my cells with my dates in them,
the
columns get very skinny. I tried changing the gap and the overlap,
with
no
success. Help! How can I get my columns to look nice and wide, and
still
have my weeks listed in my x axis??

If you're not using Excel 2007, you can enter the axis scale parameters in
convenient formats, like 0:00:10 for ten seconds or 1:00 for one hour. When
you revisit the dialog, Excel will have converted the time values into their
decimal equivalents. Excel 2007's dialogs unfortunately do not recognize
entries with these formats.

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


"Hoosierquilt" wrote in message
...
That's correct, the values are in seconds, such as :02, :03, :04, etc. up
to
about :08 seconds (we're quick to answer our phones).

I have the secondary axis checked, and my seconds are defined as time in
seconds in the cells (Time=13:30:55). The problem is in defining the
secondary axis in seconds. When I open up the "Format Axis" box, the
values
in the "Scale" tab are numeric. I have the "Number" tab set to Time
(13:30
or 13:30:55, it doesn't seem to make a difference), but it's the "Scale"
tab
that defines the increments, and that's a number, not a time value. Any
other
suggestions??

"Jon Peltier" wrote:

These points read zero, but they're not zero?

To get a series onto secondary axes (and to add secondary axes if they
aren't yet present) you double click the series, and on the Axis tab,
choose
Secondary.

How are your seconds defined in the worksheet? Are they times, formatted
something like hh:mm:ss or mm:ss or [s]? Your secondary axis should be
formatted the same. If the axis is formatted as whole numbers, the
seconds
would appear as zeros, since one second is 0.000011574 days (i.e., 86,400
seconds per day).

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


"Hoosierquilt" wrote in message
...
BRILLIANT. That did it, Jon, egads, why didn't **I** think of that. I
chose
all the other selections. Who would of guessed it (not me). Okay,
another
question on the same damned chart: I am trying to plot some differing
data
(ergo, a secondary axis, that much I know). My first data points as I
mentioned are whole numbers (I run a call center, and I'm looking at
total
incoming calls, total outbound calls, and Ave. answer time in seconds).
So,
the third data set is in seconds, not whole numbers. I've got my
secondary Y
axis selected, chosen a line graph, set the secondary y axis in
seconds,
and
I've captured all my weeks worth of ave. answer times in seconds over
the
weeks, but all the data points read as zero. The nice little pink line
is
laying flat on the x axis. When I float my mouse over the data points,
they
all read as zero. How do I get my nice little line to follow the
secondary y
axis on the right side of the chart?

"Jon Peltier" wrote:

The time scale axis has no Weeks setting. If Excel recognizes your
dates
as
dates, it will use Days instead, so for each weekly data point you
will
have
one column and six spaces, hence your thin columns. Change the time
scale
axis to a regular category axis by going to Chart menu Chart Options

Axes, and selecting Category under Category (X) Axis.

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


"Hoosierquilt" wrote in
message
...
Help. I am creating a chart that shows quantity (in whole numbers)
for
several different data sets per week in columns. The x axis is
supposed
to
be in weekly intervals. If I do not include the cells with the
weeks
listed
in my x axis labels field in the "Source Data", my columns look
great -
nice
and wide, easy to see. Once I select my cells with my dates in
them,
the
columns get very skinny. I tried changing the gap and the overlap,
with
no
success. Help! How can I get my columns to look nice and wide, and
still
have my weeks listed in my x axis??