Trying to make a grid that prints equal rows & columns. Want to use this grid for floorplans. Have even tried measuring the screen! Everything so far does not print out correctly when adjusted to 35% to encompass a 10 x 13 room. All suggestions welcome.

I hope some body can help me.
I am tracking occurances on a certain behavior. I was able
to create a series for every day of the week in a month. I
don't want to count the total. I just want to know on what

I'm trying to create a "dynamic phonebook" using Pivot.
I.e. I can select from Page e.g. City and department, in
Row Field there's listed Role and Name and In Data Items
phone number and email-address.

My chart have color and patterns at my office but not at
home... i used to have color and patterns at home
please help

Posted 24 hours ago on ms.public.office.vba, but got no reply:
Hi
I'm creating a type of auto-graph routine in VBA Excel 2000 and I want
it to remain very flexible. I decided that I would code only very

We have a requrement for a line chart that shows a maximum, minimum
and average value plotted across a period of time.  For this
particular chart we need to fill the area between the maximum and
minumum values with a solid colour to help the variation between the

Hi, I am trying to create a pie chart from the below data
just to show the percentages of what work orders are maj,
med and min. How do I set this up!!
Thanks in Advance!!!

Does anyone know a way to automatically draw the vertical
line that intersects with another plotted line using the XY
scatter charts

i just noticed that when i hide my datat table, my charts
go blank.  is this normal?  if so, is there any way to
chart hidden data?
thanks for the help.

The below Auto_Close is suppose to restore the screen
display  and workbook tabs (toolbars and tabs visible
again)when the user closes the window by clicking the "X"
button. Auto_Close doesn't work. Can someone help me with

A rookie at this.  I have a simple database of about 100
rows and 20 columns; I need to build a pivot chart so
that things like "actual cost per item" can be compared
to a "target" and to a "stretch target"...at the same

X-Y Scatter line chart.
When using daily dates on the X-axis (eg equity price chart) how can
you get the axis labels to just show the 1st of every month. Also what
is the best way to show vertical grid lines corresponding to the first

Is there a way to make this array formula ignore and error
message in a cell in the range?
{=INDIRECT(ADDRESS(MAX((ROW(19:30)*
(X19:X30<>""))),COLUMN(X:X)))}

I have just created a chart, but rather than show each
data series individually, it has added them together.
Hence the first data series shows the values from Column A
of my Sheet correctly, but the second series shows the

We have a workbook with vba code which fetches data from
the backend and displays it. Now i have a chart defined
for some data in this workbook and then i refresh this
workbook.