|
|
Data for Chart with Blank Formula Cells by
Frank Kabel
Hi Sue
in your formula try returning NA() instead of ""
e.g.
IF(condition,yourformula,NA())
Frank
I am trying to chart a worksheet that contains many...
|
|
1 |
371 |
|
|
Chart Title Length by
Kurt Mease
Working with Excel 2000. Does anyone know how to change
the character limitation for an Excel chart title? I am
trying to type more into the chart title box...
|
|
1 |
216 |
|
|
|
|
1 |
128 |
|
|
How to export multiple charts from Access by
Ian Millward
I need to export several tables and charts from an Access 2000 db into Excel
2000 because Access is very limited for displaying Charts. Ideally, I would
like...
|
|
6 |
439 |
|
|
|
|
1 |
375 |
|
|
adding lines to a chat by
engineeringstudent
How do I add a vertical line in a graph, that begins at the x-axis and continues to the upper limits of my graph? I need this line to cross a plotted...
|
|
1 |
204 |
|
|
Changing line color within a chart by
Dwayne Smith
I have a spreadsheet that tracks the gas mileage for my vehicle and
displays it in a simple line graph. I have moved to different parts
of the country a...
|
|
3 |
287 |
|
|
x-axis values by
Sam Beardsley
This one's for my 7th grader. He's got events 1-14 in one
column. He's got the value of each of those events in the
next column. All of the values are...
|
|
2 |
134 |
|
|
X Axis Category Label not appearing by
Janna
I've created a chart with X Axis Category labels--they're months, Nov-03, Dec-03, Jan 04. Beneath the rightmost X axis, though the chart data points are...
|
February 13th, 2004 09:41 PM
by Janna
|
0 |
413 |
|
|
|
|
3 |
314 |
|
|
Creating a time chart by
Don Rountree
Can someone tell me if this is possible. I want to be able to create a
chart that represents a week. There will be seven bars and each bar will
represent the...
|
|
1 |
307 |
|
|
Format Y-axis value ? Urgent by
Tushar Mehta
In XL, turn on the macro recorder (Tools | Macro Record new
macro...), change the y-axis scale maximum by hand, and turn off the
recorder. XL will give you...
|
|
0 |
87 |
|
|
|
|
2 |
437 |
|
|
Adding documentation to VBA functions. by
Jacques Maartens
Hi
How do I add documentation/desriptions for VBA functions or function
variables?
I have tried to add a description to a function's properties under...
|
|
1 |
142 |
|
|
Focus / Targeting Lines on a Chart by
Max
Hi guys,
Let's say I have a chart in a chartsheet.
I'll like a visual aid to be able to direct, say, a discussion's focus
from one point on the chart to...
( 1 2)
|
|
18 |
1,091 |
|
|
|
February 12th, 2004 10:53 PM
by L Mehl
|
2 |
965 |
|
|
Starting x-axis at zero? by
Jon Peltier
Zach -
Use an XY Scatter chart instead of a Line chart. See these links for
more information:
Scatter Chart or Line...
|
|
0 |
251 |
|
|
Help! Chart losing date format by
Jon Peltier
Rollin -
The date format problem happens because the axis formats are probably
linked to the source data. As long as the source data is in an open
workbook,...
|
|
0 |
604 |
|
|
force graph to axis of choice by
bbxrider
i have a bar chart and when then added an xy scatter chart
i want the scatter chart to use the primary axis but it seems to insist on
using the 2ndary axis
i...
|
|
2 |
635 |
|
|
Data for Chart with Blank Formula Cells by
sparrowsm
I am trying to chart a worksheet that contains many formulas. When the
result of the formula is zero, the cell is instructed to leave the cell
blank (which is...
|
|
0 |
344 |