Link from Chart File to Data File / Format Problem
Thu, 31 Jul 2008 14:15:00 -0700
I have two Excel files. One file with the chart and a second file with the
data range. I have the data range properly formatted with currency. When I
open the file with the chart, the chart has all the numbers from the data
file. However, the currency formats do not flow through from the data file
to the ...
|
If formulas
Thu, 31 Jul 2008 12:56:01 -0700
I'm trying to set up a spread sheet that will replace names for the numbers.
Example:
if"333-333-3333, than "Scott"
I want to have this formula on the entire spreed sheet. Can anyone help?
--
Chris ...
|
Dynamically Shifting Ranges
Thu, 31 Jul 2008 09:45:01 -0700
I use charts to display 21-periods of data. Every period new data is
entered, and I have to mannually change the range of values for each series
to a new 21-row range. From last period's range of "Sheet!L50:L70" to the
new period's range of "Sheet!L51:L71" for example.
I'm not clear about how to name and ...
|
how do I get rid of the dark lighting under surface plot chart?
Thu, 31 Jul 2008 09:31:05 -0700
I have created a 3d surface plot - Chart
On the underside of this surface is a dark 3D lighting effect.
How do I get rid of this? ...
|
how do I get rid of the dark lighting under surface plot chart?
Thu, 31 Jul 2008 09:30:02 -0700
I have created a 3d surface plot - Chart
On the underside of this surface is a dark 3D lighting effect.
How do I get rid of this? ...
|
Problem Printing Excel Charts
Thu, 31 Jul 2008 07:55:00 -0700
Iâ??m using Office 2007 with SP1. Iâ??m having problems printing charts that are
inserted into their own sheet when they are fit and printed to 11x17. The
printed chart will cut off about 3 inches at the bottom. If I resize the
chart about 3 inches shorter it prints, but I want it to fill the entire
page. ...
|
Macro Help Needed
Thu, 31 Jul 2008 07:14:06 -0700
Hello,
Can someone help me, I am trying to create a macro in excel that allows me
to create a copy of a worksheet, clear its contents then hyperlink it to a
particular cell.
The problem is that I want it to link a different page to a different cell
every time i.e. create sheet 2(3) and link to R3. create ...
|
|
|
Row Grand Totals in Pivot Tables?
Wed, 30 Jul 2008 14:02:02 -0700
I'm working in Excel 2007 and I can't seem to see my row grand totals in my
pivot table. I can see the grand totals on the columns, but no rows. Any
ideas? ...
|
Getting Trend Line Info from Chart
Wed, 30 Jul 2008 18:40:21 GMT
Hi -
I am creating a manpower report and updating learning curve charts for a
decision making tool through VBA. The issue I am having is the trend line
(Power) in the charts gives me the output I need but I cannot figure out how
to pull the values I want into the spreadsheet. I have tried a couple of
function ...
|
Excel Chart Window
Wed, 30 Jul 2008 10:54:06 -0700
In Excel 03, you could right click on a chart and choose "Chart Window" to
open up a temporary window that could be expanded without changing the
position/size of the underlying chart. I can't seem to find this command in
2007 and, as a result, if I want to look at a chart more closely will have to
resize i ...
|
