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??