Cell Reference updating
Wed, 20 Aug 2008 04:19:01 -0700
I have created a excel file and in it there is a sheet that is copied each
month and then it data is filled in during the month, the data is charted as
it's entered, and all is well. This same excel file is in use on a different
computer. The file was originally created with excel 97-2003 and updated to
200 ...
|
cycle time
Tue, 19 Aug 2008 15:14:02 -0700
HI,
I need help in capturing a cycle time from the time the form was intiated
and submitted to the time it was fully approved. But in between those
process are other folks approval that I need to track too the cycle time.
example:
intiated and routed to ab on 8-1-08
aprroved by AB and routed to CD on ...
|
Excel 2007 and chart as chartsheet
Tue, 19 Aug 2008 18:07:13 -0400
I have code that moves a new chart from its worksheet to a chartsheet and
changes its orientation to portrait. The resulting chart only fills about
two thirds of the page. There is a big blank area at the bottom. I can
manually change the plotarea to make it fill the entire page, but I can not
do so via a ...
|
Chart print preview and print formatting
Tue, 19 Aug 2008 11:02:08 -0700
I have a scatter chart containing 7 series. The chart is an embedded object
located on an Excel 2003 work sheet. If I select the chart and some cells
around the chart that contain some other data that I want to print and then
do a print preview, the plot area of the chart grows vertically to the point
where ...
|
#N/A isn't charting in VBA
Tue, 19 Aug 2008 17:48:05 GMT
I was told in the programming group to come here. I have a problem I'm hoping
someone can give me a hand with. I've been asked to create the ability to
make charts on any page of a workbook by clicking a button on the worksheet.
I've been able to do that, except that there is data from three non-
contiguous rows ...
|
moms beregner
Tue, 19 Aug 2008 08:32:07 -0700
Hej
Jeg ville godt have at der var en momsberegner til når man skulle angive
moms til SKAT.
Så jeg kunne sætte hele mit kontoudtog ind og så tog den selv og regnede
momsdelen ud.
Findes en sådan skabelon og hvor?
Mvh. Søren ...
|
How to show numbers on y-axis and percentages on data labels?
Mon, 18 Aug 2008 12:47:04 -0700
I have a two data series to place on a chart (chart type = stacked column).
I would like to have the y-axis show the numbers and the data labels show the
percentage of total for that particular data point.
For instance:
x-axis Pass Fail PDL FDL
point1 7 5 58% 42%
point2 1 6 14% 86%
point3 8 8 50% 5 ...
|
|
|
Points Dimensions on a 3D Clustered Column Chart
Mon, 18 Aug 2008 11:27:01 -0700
Hi,
Need some valuable help on this:
I' ve got a 3D Clustered column Chart. I'd like to have the coordinates for
each point in a particular series. It's like when you move the mouse over any
point, it shows you a tip with the value and the name for that point. Well I
Need to have control on those coordinates ...
|
print a chart over multiple pages
Mon, 18 Aug 2008 08:40:01 -0700
I am trying to stretch a chart over multiple pages, but i just can't get it
to work. I have tried all i can think including attempting to print areas
individually.
Any ideas?
i'm using excel 2003.
Thanks ...
|
callouts on graph
Mon, 18 Aug 2008 05:06:01 -0700
When I add callouts to a chart, some of them stay in place and some disappear
when I click away from the chart. I have tried to bring them forward and
send the chart to the back but still the same results. Any help? ...
|