|
|
|
|
0 |
128 |
|
|
Suppress Zero On a Chart by
Jerry W. Lewis
Use #N/A instead of "" for null values.
Jerry
Bob Barnes wrote:
I have Souree Data for a Chart with some Null Values.
However, they appear as Zero on...
( 1 2)
|
|
11 |
386 |
|
|
Changing Chart SourceData in VBA by
JimPNicholls
Excel 97.
Can anyone spot where I'm going wrong? I'm trying to
change the source data in code so it only shows upto the
last cell that has a value in it. My...
|
|
4 |
216 |
|
|
Gantt Chart and Critical Path by
Royce
I have a spreadsheet where I enter time line data in the
cells and from that information generate a Gantt chart.
What I would like is a way to have symbols on...
|
|
1 |
108 |
|
|
histogram to radar chart by
David
In a frequency histogram the area represented by the bars in the chart is area proportional, if after the histogram is created it is converted to a radar chart...
|
|
1 |
285 |
|
|
Programmatically select data range by
neilvk
Hi All,
How is it possible to select a data range by using variables?
i.e. instead of range(A:1,c:3) have range(i,j)
Here is my code, the line with the...
|
|
3 |
194 |
|
|
Counting cells using multiple criteria by
Atchy
I am using Excel 2000. And, I need to count cells that
fall in multiple criteria. For example, I have 5 numbers
93.84, 100, 95, 92.5, and 92.5 in cells from...
|
|
2 |
408 |
|
|
|
|
0 |
284 |
|
|
"Extra" Rows and Columns by
Shane
Greetings,
A bunch of us are re-introducing ourselves to Excel 2000
at work and so far doing alright. We have noticed,
however, that while we're editing...
|
May 7th, 2004 11:47 AM
by Shane
|
2 |
790 |
|
|
Unusual Chart Type? by
Jon Peltier
Follow your instincts, and use numbers for states, {1,2,3,4,5} for
{A,B,C,D,E}. Make your chart. Then use the technique on this page to put
the labels where...
|
|
3 |
230 |
|
|
Printing JUST the Charts, not the data... by
Shane
Hi,
I'm using Excel 2000 and have a number of worksheets with
which I've created some charts (all in the same
workbook). Is there a way to print the charts...
|
|
5 |
269 |
|
|
Two Pie Charts in One Chart Sheet by
ExcelMonkey
Is it possible to build two pie charts (side by side) in one chart
sheet?
Thanks
---
Message posted from http://www.ExcelForum.com/
|
|
1 |
94 |
|
|
Area Under Curve by
Mark
Does anyone know how to determine the area under a curve from an Excel chart???
I've tried to use the "Area Chart" function in Excel but I can't find where it...
|
|
1 |
247 |
|
|
Subscript out of range Error by
Jon Peltier
Hi Leanne -
I don't see UpdateSPWebLinks in my VBE Object Browser. It must be part
of a third party solution. When you installed everything on the...
|
|
4 |
237 |
|
|
Data Series by
Bill
How can I count the number of series in a particular chart using VBA. I have tried ActiveChart.SeriesCollection.Count but it doesn't work. Thanks
|
|
1 |
92 |
|
|
Changing size of chart area by
Dinz
How do I reduce the size of the chart area? I've made
the plot area smaller and would like to decrease the
white space in the chart area. Many thanks.
|
|
1 |
336 |
|
|
Current Date Time Line by
Gail
I am using a bar graph to display a list of projects
where each project has a start date and an end date. The
chart is set up for a 3 year time frame with the...
|
|
1 |
394 |
|
|
Maximum point of graph by
Jerry W. Lewis
Terminology: This is a 3rd order polynomial, not a 4th order.
Caveat: Unless you have external knowledge that the form of your model
(cubic in this case) is...
|
|
3 |
309 |
|
|
Connect the dots? by
Febra
Is there a way to connect the plot points in a line chart when the plot points are a calculated point? In the pregnancy weight gain chart that I am working on...
|
May 5th, 2004 03:41 PM
by Febra
|
3 |
196 |
|
|
|
|
3 |
145 |