I have a spreadsheet that tracks certain events that can occur within
hours of each other, or within a couple of days.  I need to chart this
data on a realistic timescale, so that events that occurred within a
few hours of each other will appear to be physically closer on the

I would appreciate some suggestions on how to automate a
chart's x-axis values. For instance, I would like to be
able to have my chart update to the last 30 days of data
so that each time the file is opened, the data is updated

I have a pivot chart that shows over the last 12 months
the number of units sold. The data it relates too has the
date the unit was sold i.e dd/mm/yy and the stock code
which it counts from.

I have converted the standard notation of DDD.MMSS (degrees minutes and
seconds) used for land surveys into angles (for use with Excel) with the
following results:
DDD.MMSS         ANGLE       Distance

i need to do an Excel graph that combines two graphs.
for example, weight VS time, and height VS time.
the X axis is the same, the Y axis is from two sources.
is it possible?

I am trying to create a multiplication chart.  I am trying
to "fill right" my formula to make it easy, HOWEVER, the
formula changes.  So, it goes A1, then B1, then C1 etc.  I
know there is a way to make it so that the number always

I have a small spreadsheet with very simple data.  I have
not made any changes to any fonts, but as soon as I try
to create a chart from the data, I get a message
saying "No New Font Can Be Added".

How do I change the default chart background color?  I
don't like the grey and I always change if to white.  I
have to do it manually every time.  Is there a way to
change the default?

I have categorized jobs on a scale of 1-10 for Ease of
Implementation (1=hard, 10=easy) and 1-10 for Value
Returned. I want to plot these so the easy, high value
jobs appear in the upper-right quadrant, hard, low-value