Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
Hi,
Well, Excel _does_ X-Y graphs, but not this one. I have, in the columns A, B, G, and E from row 7 to 5175, sequential time, data, and data (and dummy data) , respectively. When I make an X-Y plot using the time column for the X-axis, it plots as expected. But when I plot column B versus column D, I get column B on the Y-axis, and the (relative?) row number on the X-axis. (There are gaps in the data, but any gaps plot alright in a smaller data sub set, even if they are not matched). My workaround consists of plotting B versus D and E, and then remove E ;-) Somehow it seems Excel won't make a proper X-Y plot properly if just two columns are given. (because of the large number of rows? and/or the gaps, and/or because the E column had no gaps) Can anybody explain? Best regards / Ake |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
Sorry, my "workaround" was a red herring. The problem remains... some data
sets still won't plot as X-Y/ Ake |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
If the data in the X range are not numeric (even if only one is not
numeric), then Excel will treat the values as labels, and use the counting numbers 1, 2, 3, etc. as X values. If your blanks are "" returned by a formula, you should know that "" is a piece of text, not a blank, and is either treated as a zero or treated as a non-numeric X value. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ake" wrote in message ... Sorry, my "workaround" was a red herring. The problem remains... some data sets still won't plot as X-Y/ Ake |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
Thanks a lot Jon,
That's it. I did not realize that "" is in fact a string. And I did my small data set testing using "no data" instead of "" which I thought meant the same thing. So I got confused by the results. So, how should I actually do IF(Condition;Something;"") then? The reason I use it is that it works well on the Y-data, and that the table I plot from looks "as clean as it is" (I don't want to fill all empty cells with "########"). Is there a workaround, or even some way to force the plot to "think right". Thank's again for clearing this up / Ake |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
You have failed to quote any of the message to which you are replying, so I
don't know what has already been suggested, but if you don't want the chart to plot your "" as a zero value, try changing IF(Condition;Something;"") to IF(Condition;Something;NA()) -- David Biddulph "Ake" wrote in message ... Thanks a lot Jon, That's it. I did not realize that "" is in fact a string. And I did my small data set testing using "no data" instead of "" which I thought meant the same thing. So I got confused by the results. So, how should I actually do IF(Condition;Something;"") then? The reason I use it is that it works well on the Y-data, and that the table I plot from looks "as clean as it is" (I don't want to fill all empty cells with "########"). Is there a workaround, or even some way to force the plot to "think right". Thank's again for clearing this up / Ake |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
Yes, you are right. But that solves the plotting problem only- but it still
does show up as irritating (to me ;-) text in the table, rather than "empty space". /Ake "David Biddulph" wrote: You have failed to quote any of the message to which you are replying, so I don't know what has already been suggested, but if you don't want the chart to plot your "" as a zero value, try changing IF(Condition;Something;"") to IF(Condition;Something;NA()) -- David Biddulph "Ake" wrote in message ... Thanks a lot Jon, That's it. I did not realize that "" is in fact a string. And I did my small data set testing using "no data" instead of "" which I thought meant the same thing. So I got confused by the results. So, how should I actually do IF(Condition;Something;"") then? The reason I use it is that it works well on the Y-data, and that the table I plot from looks "as clean as it is" (I don't want to fill all empty cells with "########"). Is there a workaround, or even some way to force the plot to "think right". Thank's again for clearing this up / Ake |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
You can deal with the "irritating ... text" in the table by conditional
formatting, colouring the font white (or your cell's background colour) if the cell satisfies the CF condition/ Formula is/ =ISNA(A1) -- David Biddulph "Ake" wrote in message ... Yes, you are right. But that solves the plotting problem only- but it still does show up as irritating (to me ;-) text in the table, rather than "empty space". /Ake "David Biddulph" wrote: You have failed to quote any of the message to which you are replying, so I don't know what has already been suggested, but if you don't want the chart to plot your "" as a zero value, try changing IF(Condition;Something;"") to IF(Condition;Something;NA()) -- David Biddulph "Ake" wrote in message ... Thanks a lot Jon, That's it. I did not realize that "" is in fact a string. And I did my small data set testing using "no data" instead of "" which I thought meant the same thing. So I got confused by the results. So, how should I actually do IF(Condition;Something;"") then? The reason I use it is that it works well on the Y-data, and that the table I plot from looks "as clean as it is" (I don't want to fill all empty cells with "########"). Is there a workaround, or even some way to force the plot to "think right". Thank's again for clearing this up / Ake |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
Yes thank you, that does the job. I still think that MS should consider a way
to imprint "Empty" in a cell from a formula, now that "" does not do that. / Ake "David Biddulph" wrote: You can deal with the "irritating ... text" in the table by conditional formatting, colouring the font white (or your cell's background colour) if the cell satisfies the CF condition/ Formula is/ =ISNA(A1) -- David Biddulph "Ake" wrote in message ... Yes, you are right. But that solves the plotting problem only- but it still does show up as irritating (to me ;-) text in the table, rather than "empty space". /Ake "David Biddulph" wrote: You have failed to quote any of the message to which you are replying, so I don't know what has already been suggested, but if you don't want the chart to plot your "" as a zero value, try changing IF(Condition;Something;"") to IF(Condition;Something;NA()) -- David Biddulph "Ake" wrote in message ... Thanks a lot Jon, That's it. I did not realize that "" is in fact a string. And I did my small data set testing using "no data" instead of "" which I thought meant the same thing. So I got confused by the results. So, how should I actually do IF(Condition;Something;"") then? The reason I use it is that it works well on the Y-data, and that the table I plot from looks "as clean as it is" (I don't want to fill all empty cells with "########"). Is there a workaround, or even some way to force the plot to "think right". Thank's again for clearing this up / Ake |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
"" has never done that. We have asked for such a BLANK() or NULL() function,
but have never seen such. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ake" wrote in message ... Yes thank you, that does the job. I still think that MS should consider a way to imprint "Empty" in a cell from a formula, now that "" does not do that. / Ake "David Biddulph" wrote: You can deal with the "irritating ... text" in the table by conditional formatting, colouring the font white (or your cell's background colour) if the cell satisfies the CF condition/ Formula is/ =ISNA(A1) -- David Biddulph "Ake" wrote in message ... Yes, you are right. But that solves the plotting problem only- but it still does show up as irritating (to me ;-) text in the table, rather than "empty space". /Ake "David Biddulph" wrote: You have failed to quote any of the message to which you are replying, so I don't know what has already been suggested, but if you don't want the chart to plot your "" as a zero value, try changing IF(Condition;Something;"") to IF(Condition;Something;NA()) -- David Biddulph "Ake" wrote in message ... Thanks a lot Jon, That's it. I did not realize that "" is in fact a string. And I did my small data set testing using "no data" instead of "" which I thought meant the same thing. So I got confused by the results. So, how should I actually do IF(Condition;Something;"") then? The reason I use it is that it works well on the Y-data, and that the table I plot from looks "as clean as it is" (I don't want to fill all empty cells with "########"). Is there a workaround, or even some way to force the plot to "think right". Thank's again for clearing this up / Ake |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
Would it really upset the VB syntax that much if "" was considered as empty
as if no characters at all had been entered? / Ã…ke "Jon Peltier" wrote: "" has never done that. We have asked for such a BLANK() or NULL() function, but have never seen such. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ake" wrote in message ... Yes thank you, that does the job. I still think that MS should consider a way to imprint "Empty" in a cell from a formula, now that "" does not do that. / Ake "David Biddulph" wrote: You can deal with the "irritating ... text" in the table by conditional formatting, colouring the font white (or your cell's background colour) if the cell satisfies the CF condition/ Formula is/ =ISNA(A1) -- David Biddulph "Ake" wrote in message ... Yes, you are right. But that solves the plotting problem only- but it still does show up as irritating (to me ;-) text in the table, rather than "empty space". /Ake "David Biddulph" wrote: You have failed to quote any of the message to which you are replying, so I don't know what has already been suggested, but if you don't want the chart to plot your "" as a zero value, try changing IF(Condition;Something;"") to IF(Condition;Something;NA()) -- David Biddulph "Ake" wrote in message ... Thanks a lot Jon, That's it. I did not realize that "" is in fact a string. And I did my small data set testing using "no data" instead of "" which I thought meant the same thing. So I got confused by the results. So, how should I actually do IF(Condition;Something;"") then? The reason I use it is that it works well on the Y-data, and that the table I plot from looks "as clean as it is" (I don't want to fill all empty cells with "########"). Is there a workaround, or even some way to force the plot to "think right". Thank's again for clearing this up / Ake |
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel (2007) won't do a particular X-Y (Point) graph for me..
That's the way it is.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ake" wrote in message ... Would it really upset the VB syntax that much if "" was considered as empty as if no characters at all had been entered? / Åke "Jon Peltier" wrote: "" has never done that. We have asked for such a BLANK() or NULL() function, but have never seen such. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ake" wrote in message ... Yes thank you, that does the job. I still think that MS should consider a way to imprint "Empty" in a cell from a formula, now that "" does not do that. / Ake "David Biddulph" wrote: You can deal with the "irritating ... text" in the table by conditional formatting, colouring the font white (or your cell's background colour) if the cell satisfies the CF condition/ Formula is/ =ISNA(A1) -- David Biddulph "Ake" wrote in message ... Yes, you are right. But that solves the plotting problem only- but it still does show up as irritating (to me ;-) text in the table, rather than "empty space". /Ake "David Biddulph" wrote: You have failed to quote any of the message to which you are replying, so I don't know what has already been suggested, but if you don't want the chart to plot your "" as a zero value, try changing IF(Condition;Something;"") to IF(Condition;Something;NA()) -- David Biddulph "Ake" wrote in message ... Thanks a lot Jon, That's it. I did not realize that "" is in fact a string. And I did my small data set testing using "no data" instead of "" which I thought meant the same thing. So I got confused by the results. So, how should I actually do IF(Condition;Something;"") then? The reason I use it is that it works well on the Y-data, and that the table I plot from looks "as clean as it is" (I don't want to fill all empty cells with "########"). Is there a workaround, or even some way to force the plot to "think right". Thank's again for clearing this up / Ake |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Map Point Plug-in for Excel 2007 | Excel Discussion (Misc queries) | |||
excel chart showing movable graph at what point we make a profit | Charts and Charting in Excel | |||
how do i export a graph from excel to power point? | Charts and Charting in Excel | |||
How do I point out a specific date on a line graph in Excel? | Charts and Charting in Excel | |||
Excel should let you graph every n-th data point in a column | Charts and Charting in Excel |