Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can't use NA() instead of "" but then pb in chart with zero values
I have column that are created from the IF formula which returns the ""
values if the result is false. I can't use NA() instead because then, I am using these columns for other calculations such as average. I need to use those columns also to create charts, but my lines with "" are showing zero values. I read in this forum that we can use a trick solution: to have a column using "" for the calculation and another using NA() for the graph. If I have too many coumns, is there an easier way to solve it? Thank, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can't use NA() instead of "" but then pb in chart with zero values
What is "too many" columns? In my experience, it's better to use as many
columns as needed, even to the point of using separate worksheets, one for original data, one for calculations, one for chart source data, one for the printed report, etc. Worksheets are cheap. Your time and effort are expensive, trying to use the same range for different purposes. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kami" wrote in message ... I have column that are created from the IF formula which returns the "" values if the result is false. I can't use NA() instead because then, I am using these columns for other calculations such as average. I need to use those columns also to create charts, but my lines with "" are showing zero values. I read in this forum that we can use a trick solution: to have a column using "" for the calculation and another using NA() for the graph. If I have too many coumns, is there an easier way to solve it? Thank, |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can't use NA() instead of "" but then pb in chart with zero va
Hi,
It is about fifty files in which I need to chart six columns. The issue is that some of these files are growing fast (30-40 thousand lines) and that the files become quickly heavy to work with. So each new column will be a new 40 thousand lines column and i am afraid it won't help the file to stay light. But you may be right anyway, at least, everything will stay organized. Thanks kami "Jon Peltier" wrote: What is "too many" columns? In my experience, it's better to use as many columns as needed, even to the point of using separate worksheets, one for original data, one for calculations, one for chart source data, one for the printed report, etc. Worksheets are cheap. Your time and effort are expensive, trying to use the same range for different purposes. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kami" wrote in message ... I have column that are created from the IF formula which returns the "" values if the result is false. I can't use NA() instead because then, I am using these columns for other calculations such as average. I need to use those columns also to create charts, but my lines with "" are showing zero values. I read in this forum that we can use a trick solution: to have a column using "" for the calculation and another using NA() for the graph. If I have too many coumns, is there an easier way to solve it? Thank, |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can't use NA() instead of "" but then pb in chart with zero va
What version of Excel? If you're on 2000-2003, the issue is only disk space,
bah! In 2007, this many records can cause problems when used in calculations or especially as a chart's source data, so performance becomes an issue. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kami" wrote in message ... Hi, It is about fifty files in which I need to chart six columns. The issue is that some of these files are growing fast (30-40 thousand lines) and that the files become quickly heavy to work with. So each new column will be a new 40 thousand lines column and i am afraid it won't help the file to stay light. But you may be right anyway, at least, everything will stay organized. Thanks kami "Jon Peltier" wrote: What is "too many" columns? In my experience, it's better to use as many columns as needed, even to the point of using separate worksheets, one for original data, one for calculations, one for chart source data, one for the printed report, etc. Worksheets are cheap. Your time and effort are expensive, trying to use the same range for different purposes. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kami" wrote in message ... I have column that are created from the IF formula which returns the "" values if the result is false. I can't use NA() instead because then, I am using these columns for other calculations such as average. I need to use those columns also to create charts, but my lines with "" are showing zero values. I read in this forum that we can use a trick solution: to have a column using "" for the calculation and another using NA() for the graph. If I have too many coumns, is there an easier way to solve it? Thank, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |