Tools - Options - Chart - Plot empty cells as: Not plotted (leave gaps) works
only when the cell is actually empty. The cell is empty when raw data is
missing, but the raw data has to be subtracted from a constant value. I'm
using =IF(ISNUMBER(B4), B$1-B4,NA()) which returns #N/A when B4 is blank.
The cell is not empty and consequently is plotted as an interpolated value
between B3 and B5.
I've tried copying and pasting values only and using "" instead of NA() to
no avail.
Short of clearing the contents manually (5% missing data points scattered
throughout 25,000 values) is there another way to leave gaps in the line
chart?

=?Utf-8?B?Q2F0ZW5hcnk=?=

=?Utf-8?B?Q2F0ZW5hcnk=?=

I want to create a simple line chart for each project; but need the ability
for the user to not plot a particular project (Y 0r N)
Proj1 Proj2 Proj3 Proj4
Y Y Y N
11.3% 8.5% 1.8% 0.9%
16.1% 12.4% 3.7% 1.5%
21.3% 16.6% 6.9% 3.9%
Any ideas?
Thanks
Saintsman

=?Utf-8?B?U2FpbnRzbWFu?=

=?Utf-8?B?U2FpbnRzbWFu?=

I want to plot one data series against two axes. I can get the secondary axes
and I can get it onto the x axes at the top. What I want is to get the second
axes to be dependent on the first. You see the second axes is the volume
fraction of a composite ply and the first is the weight fraction. I want to
create a graph so that the data series I plot can be looked up by either the
volume fraction or the weight fraction. The problem is that the volume
fraction axes scale needs to be irregular since it's a nonlinear function of
the weight fraction. Firstly, I'd like to know if that's possible.
If so,
HOW DO I DO IT?

=?Utf-8?B?RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=

=?Utf-8?B?RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=

I have a HP designjet 110 nr plotter. I've created a plot that we nee
to show drilling activity. My first plot was 24"x36". Plot works grea
and to scale. My next plot was to be 24"x72". Now the charts will no
even display in Print Preview. I can scale back the plot where it i
about 48" and it will preview and plot, but I need it to go out eve
futher than 72 inches. I may go out as far as 30 feet.
I have images on the plot area and it will print it just fine at th
farther distances
--
TexasDa
-----------------------------------------------------------------------
TexasDan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3475
View this thread: http://www.excelforum.com/showthread.php?threadid=54517

TexasDan

TexasDan

Hi all,
I am still using Excel 2003. I want to plot some 2D data, does it have
interpolation in plotting? Or I will have to do it by myself?
Thanks a lot

cfman

cfman

How do you combine a scatter plot (showing numbers on axis) with a category
plot (showing categories) and a line graph that is within the area of the
category plot?
Can Excel 2007 do this and how? All the source data is in one worksheet.
--
Janet A.

=?Utf-8?B?SmFuZXQgQS4gVGhvbXBzb24=?=

=?Utf-8?B?SmFuZXQgQS4gVGhvbXBzb24=?=

I'm working in an excel sheet in which I need to plot a ground profile graph
from the input "Distance (along x-axis) and elevation (along y-axis) which
has 30 measured points (30 points on a graph to draw the curve).
Now I need to give this information to my boss which must include the
stating point distance and elevation, end point distance and elevation and
the rate of undulation. From this data my boss will analys the profile to
mark certain parameters as critical.
Do anybody have an idea how to do it.

=?Utf-8?B?MjIyNg==?=

=?Utf-8?B?MjIyNg==?=

After printing a pie chart, the plot area relocates itself. I wrote a
procedure to bring it back to the designated "top" and "left" coordinates
the next time the sheet is activated, but the plot area doesn't relocate
until the sheet is activated a SECOND time. Does anyone know how to fix?
Thank you.

JD

JD

I am having difficulty with Excel and was hoping someone
could be of assistance.
I am plotting a series of graphs with time on the x-axis
and water level on the y-axis. The first set of graphs
looks good. If you put the pointer over one of the points
on the x-y scatter plot graph you see: "EW-5 Pump Test"
Point "4321.00" (4321.00, 2445.04) 4321.00 is time in
minutes and 2445.04 is the water level in feet.
However, my next series of graphs for the same well (plots
the same type of data for another event) looks like:
"EW-5 Recovery Test" Point "4320.00" (96,2455.67)
If you notice the "EW-5 Recovery Test" is using the time
in minutes as the name of the point, the cell number as
the x-axis, and the water level as the y-axis. I have
double checked everything and can't figure out why excel
would be doing this. I used the first graph as a template
for the second graph and have verified under "source data"
that it should be using the time in minutes as the y-axis
data.
Any help would be appreciated!

Annoyed by Excel

Annoyed by Excel

Dear member,
I have a question . The question is how
to make a graph=85.I do know your name or kind
For example I have range the value of mean and variance. I need to
plot the two in same graph how is attachad .
mean var
tn 287.787 120.619
t12 2.147.523 13.843.230
t18 2.698.113 22.254.429
t24 3.288.497 17.780.971
td 1.841.121 7.918.387
Anyone have one idea.. how to make it?
Thanks&Regards
Jen

jen

jen

How do I do a stairstep plot? Vertical lines have length one.
Horizontal lines can have any length.
John Adams
Bethlehem, PA

John

John

Hi,
is Excel able to color the bars of a bar chart according to the height
of the respective bar?
The surface plot would be an alternative but I cannot change the
colors?
Can anybody help?
Chris

chris.ammann

chris.ammann

(I'm trying here the Adv Opt Cross post for the 1st time)
Hello;
There's a good chance that some might have already posted this question
(including myself!), but I couldn't find any related threads in this forum
directly addressing the problem.
Suppose you've a 2D chart displaying the fuselage of an airplane nicely
proportional on the Full Screen of your desktop monitor.
You copy the w/b to your laptop and the display is completely out of
proportion because of the different aspect ratio of the screen.
Q1: Instead of Full Screen display, would a Custom View help in maintaining
the aspect ratio of the 2D plot regardless of monitor size ??
Q2: Does XL 2007 provide options for specifying the physical dimensions of
the chart area and/or plot area ??
Your expert insight would be greatly appreciated.

=?Utf-8?B?bW9uaXI=?=

=?Utf-8?B?bW9uaXI=?=

I have a spreadsheet that has a chart tab with a plot of data from another
part of the spreadsheet. Now, however, the chart is empty and when I try to
send any plot to a chart tab the plot is lost and the chart tab is empty.
This is happening now in all my spreadsheets the plot can be created within a
spreadsheet but as soon as I move it to a tab the plot is lost and the chart
tab has nothing in it. !!!????!!!!

=?Utf-8?B?U2lt?=

=?Utf-8?B?U2lt?=

I need to plot equations expressed in (r, theta) coordinates, WITHOUT first
converting them to Cartesion (x,y) coordinates. Can anyone advise if Excel
has this capability - if so, I certainly have not been able to find
it!.....Thanx

=?Utf-8?B?bWp6b2Nj?=

=?Utf-8?B?bWp6b2Nj?=

I need to plot my data as individual series on an x-y plot (i.e. each
series only contains one point) and add an intercept line through one
of these series. In versions of Excel prior to 2007, I was able to add
a trend line to a series (again, a single point) and then format it
such that it went through the x- or y-intercept of my choice; however,
in Excel 2007 I am not able to do this. If I add a trend line, it will
appear in the legend, but I will be unable to format it and it does
not appear.
I have found a way around this by adding the intercept to the data
series, but this involves reorganizing my data and it is not ideal. Is
there any other way to do this, or is there a possibility of this very
useful feature returning to Excel?
Thanks.

Brian McEwan

Brian McEwan

I have a column of data that has various times listed. I am trying to
find out how to plot some type of histogram or frequency chart that
shows what are the busiest hours.
For example column A lists the following times (in 24 hour format)
7:57
9:55
11:16
11:24
11:32
12:13
12:25
12:50
13:09
13:33
I want to be able to plot something that returns from 7:00 - 7:59 there
was 1 hit, from 9:00 - 9:59 there was 1 hit, from 11:00 - 11:59 there
were 3 hits, from 12:00 - 12:59 there were 3 hits, and from 13:00 -
13:59 there were 2 hits.
Thanks in advance!
--
trebor18
------------------------------------------------------------------------
trebor18's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28187
View this thread: http://www.excelforum.com/showthread.php?threadid=477181

trebor18

trebor18

=?Utf-8?B?RlRpYW4=?=

Any idea what's causing this or how to fix it?
In a line chart showing multiple series plotted over time, many of the
points are plotted at the wrong level (wrong height along on the Y axis),
although the data value is correct (as shown in the "tool tip" when hovering
over the plotted point).
For example, here are consecutive values for 3 series:
9, 2, 3, 3, 2 plotted as: 14, 7, 4, 5, 4
4, 4, 1, 1, 1 plotted as: 5, 5, 1, 2, 2
0, 1, 0, 1, 1 plotted as: 1, 1, 0, 1, 1

=?Utf-8?B?TG9yaSBILg==?=

=?Utf-8?B?TG9yaSBILg==?=

I have the latest version of Excel and the XP2 upgrade. Excel will not draw
scatter plots with lines everyday. Today is not a good day. It also
sometimes does not save lines drawn on plots. How do I get xy scatter plots
with lines --draw them in myself or wait til tomorrow?

=?Utf-8?B?ZXh0cmVtYTky?=

=?Utf-8?B?ZXh0cmVtYTky?=

I have a couple columns of data (about 500 rows). I apply autofilter to that
data, which filters it down to 100 rows of data. These rows are not
sequential. I would only like to plot this filtered list of data in a chart

=?Utf-8?B?Q3JhaWc=?=

=?Utf-8?B?Q3JhaWc=?=

I am trying to create an inventory model with a sawtooth effect can anyone
help?

=?Utf-8?B?S25lZXNsaWRlcg==?=

=?Utf-8?B?S25lZXNsaWRlcg==?=

I need to plot non-numeric values in a graph in Excel.
Assume I have the following data... :
X Axis Y Axis
A L
B M
C N
D O
E P
F Q
G R
I want such a graph
R x
Q x
P x
O x
N x
M x
L x
A B C D E F G
i.e. ABCD on the x axis and lmno on the y axis and the small x points are
the plots of AL, BM, CN etc..

=?Utf-8?B?TGF4?=

=?Utf-8?B?TGF4?=

Hello All, I wish to plot a scatter graph in Excel and join the points with a
smooth line. However I wish to do it using three variables (x,y and z axes)
as opposed to the simple 2D x and y axes I can easily use on excel?? Is
there a way to do this in excel??
Yours Hopefully,
Kev.

=?Utf-8?B?S2V2aW5vZnJvbXVr?=

=?Utf-8?B?S2V2aW5vZnJvbXVr?=

I have data like this:
Insufficient 1 1 3 4 1 Sufficient
Not Informative 1 2 1 4 2 Informative
Inappropriate 1 2 3 3 1 Appropriate
Incomplete 1 4 1 2 2 Complete
Irrelevant 1 1 3 2 3 Relevant
I want to plot it as a 100% stacked bar chart like this:
Insufficient @~xxx%%%%+ Sufficient
Not Informative @~~x%%%%++ Informative
Inappropriate @~~xxx%%%+ Appropriate
Incomplete @~~~~x%%++ Complete
Irrelevant @~xxx%%+++ Relevant
I can get the chart to plot the data and the left hand vertical axis labels
but not the right hand vertical labels.
Any ideas most appreciated!

=?Utf-8?B?Sm9kaQ==?=

=?Utf-8?B?Sm9kaQ==?=

Hi all,
this is a problem I have been haunted with since ages:
I cannot mix Latin with Greek letters in the legend of a plot, such as
"(DELTA)G" where (DELTA) represents here the capital letter D (DELTA) in
Greek. No problem at all in the title of a graph, or in a spreadsheet, but
not in a plot in the legend!
This is strange since other non-MS programs like Origin or Scientist can do
it beautifully!
Am I just too dumb?
Thank you,
Siggi

Siggi

Siggi

I want to generate surface plots of the form (x,y,f(x,y)). Should I just go
buy MathCAD, or can Excel manage this?

=?Utf-8?B?enp6Zml6eg==?=

=?Utf-8?B?enp6Zml6eg==?=

=?Utf-8?B?QXBhcm5h?=

Hello I am wanting to do a Log Plot (both Axis) on the following data. How
do I do this in Excel?
Stage Discharge
0.291 0.873
1.237 11.6
0.7 5.16
0.295 0.889
0.288 0.783
0.288 0.811
0.288 0.771
0.48 2.53
0.284 0.737
0.333 1.12
3.261 44.8
0.378 1.53
0.389 1.63
0.444 1.978
0.325 0.96
0.306 0.932
0.301 0.855
0.82 6.87
0.834 7.26
0.877 6.57
1.045 9.18
1.764 18
3.121 39.9
4.297 68.9
4.526 77.6
3.085 30.5
0.087 0.061

=?Utf-8?B?ZGllc2VsZGFu?=

=?Utf-8?B?ZGllc2VsZGFu?=

Hy,
I have problem with unstable format of charts in an Excel 2007
spreadsheet (under Windows XP). When I re-open a spreadsheet, the plot area
is usually contracted to a much smaller portion of the total chart area,
leaving lots of white space around the edges. This happens repeatedly with
some, but not all, of the charts in my spreadsheet. Some are x-y plots, some
are combination line, bar plots. Is there any way to keep the size of the
plot area from changing?
Thank you for help.

=?Utf-8?B?TWlyb00=?=

=?Utf-8?B?TWlyb00=?=

Hello,
I need my excel print jobs to have a footer that reports the file's "Create
Date" . Can anyone tell me how've they done this successfully?
Thanks!
Raymond

Raymond

Raymond

Is there a way to overlay a scatter plot chart on the same graph as a bubble
chart? I'm currently using Excel 2002 and I can't get it to combine ANY
other chart type with a bubble chart. Will Excel 2007 allow me to do this?

=?Utf-8?B?VGltIEg=?=

=?Utf-8?B?VGltIEg=?=

I have a template used to track the scores of grades of students.
This is the raw data (starting in Column A)
Student Form. A MP1 DIFF
A 65 49 -16.00
B 75 85 10.00
C 85 91 6.00
D 55 81 26.00
E 85 90 5.00
F 95 90 -5.00
G 70 78 8.00
H 95 68 -27.00
I 95 92 -3.00
J 80 76 -4.00
K 65 91 26.00
L 65 89 24.00
M 70 87 17.00
N 80 80 0.00
O 90 96 6.00
P 70 81 11.00
Q 95 88 -7.00
R 65 68 3.00
S 70 84 14.00
T 65 79 14.00
U 85 89 4.00
V 95 93 -2.00
w 70 86 16.00
x 65 73 8.00
y 100 92 -8.00
z 75 93 18.00
aa 85 89 4.00
bb 95 60 -35.00
I would like to add a demographic to this, such as race; I thought I would
assign a number to race and was hoping I could have the data point on the
chart change shape according to the code assigned to race.
Would anyone know if this is possible?
Any help is appriciated.
--
Jules

=?Utf-8?B?SnVsZXM=?=

=?Utf-8?B?SnVsZXM=?=

i am plotting data on log-log plot with some of the data missing that gives
zero values cannot be plotted error message. I think there must be some way
of plotting that would avoid this error message. Please let me know if there
is such a method such as use of NA() or some such function

=?Utf-8?B?cmdhbmRoaTE=?=

=?Utf-8?B?cmdhbmRoaTE=?=