| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
32,000 Data Points?
Hi All.......
I was given an Excel file that for some reason, every once in a while pops up this message......... "The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series" Just clicking off the message makes all appear ok. The charts do not appear to be affected, it's just aggravating for this thing to pop up randomly Any ideas how to clear it out, or how to find what's causing it? Vaya con Dios, Chuck, CABGx3 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
32,000 Data Points?
How many data points are being used in the chart?
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi All....... I was given an Excel file that for some reason, every once in a while pops up this message......... "The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series" Just clicking off the message makes all appear ok. The charts do not appear to be affected, it's just aggravating for this thing to pop up randomly Any ideas how to clear it out, or how to find what's causing it? Vaya con Dios, Chuck, CABGx3 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
32,000 Data Points?
Don't know for sure........there are 20-30 charts, just simple line charts
and at first glance each appears to be ok, as far as displaying the data is concerned.......thing is, I can't make the pop-up appear on demand.....dunno why it shows up.....if I could control it, maybe I could just start deleting charts untill it goes away to find out if one of them is the culpret. Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: How many data points are being used in the chart? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi All....... I was given an Excel file that for some reason, every once in a while pops up this message......... "The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series" Just clicking off the message makes all appear ok. The charts do not appear to be affected, it's just aggravating for this thing to pop up randomly Any ideas how to clear it out, or how to find what's causing it? Vaya con Dios, Chuck, CABGx3 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
32,000 Data Points?
I would be happy to look at the workbook. Just omit TRUENORTH. in my address
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Don't know for sure........there are 20-30 charts, just simple line charts and at first glance each appears to be ok, as far as displaying the data is concerned.......thing is, I can't make the pop-up appear on demand.....dunno why it shows up.....if I could control it, maybe I could just start deleting charts untill it goes away to find out if one of them is the culpret. Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: How many data points are being used in the chart? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi All....... I was given an Excel file that for some reason, every once in a while pops up this message......... "The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series" Just clicking off the message makes all appear ok. The charts do not appear to be affected, it's just aggravating for this thing to pop up randomly Any ideas how to clear it out, or how to find what's causing it? Vaya con Dios, Chuck, CABGx3 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
32,000 Data Points?
Hi Bernard.......
Thanks, but I was just getting ready to sanitize it to send to you and the problem went away. Last night I thought I isolated the specific chart that was causing the problem and was able to produce the error message on demand, but today all is well. I cannot under any circumstances make the error message pop up. I even went back three versions of the file, all of which had the problem. I guess just the "thought" of YOU looking at it, solved the problem <g. I will keep an eye on it tho, and if the problem pops back up, I'll get back in touch. Thanks for your time, Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: I would be happy to look at the workbook. Just omit TRUENORTH. in my address best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Don't know for sure........there are 20-30 charts, just simple line charts and at first glance each appears to be ok, as far as displaying the data is concerned.......thing is, I can't make the pop-up appear on demand.....dunno why it shows up.....if I could control it, maybe I could just start deleting charts untill it goes away to find out if one of them is the culpret. Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: How many data points are being used in the chart? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi All....... I was given an Excel file that for some reason, every once in a while pops up this message......... "The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series" Just clicking off the message makes all appear ok. The charts do not appear to be affected, it's just aggravating for this thing to pop up randomly Any ideas how to clear it out, or how to find what's causing it? Vaya con Dios, Chuck, CABGx3 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
32,000 Data Points?
Well done. Another problem solved notch on my gun <grin
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi Bernard....... Thanks, but I was just getting ready to sanitize it to send to you and the problem went away. Last night I thought I isolated the specific chart that was causing the problem and was able to produce the error message on demand, but today all is well. I cannot under any circumstances make the error message pop up. I even went back three versions of the file, all of which had the problem. I guess just the "thought" of YOU looking at it, solved the problem <g. I will keep an eye on it tho, and if the problem pops back up, I'll get back in touch. Thanks for your time, Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: I would be happy to look at the workbook. Just omit TRUENORTH. in my address best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Don't know for sure........there are 20-30 charts, just simple line charts and at first glance each appears to be ok, as far as displaying the data is concerned.......thing is, I can't make the pop-up appear on demand.....dunno why it shows up.....if I could control it, maybe I could just start deleting charts untill it goes away to find out if one of them is the culpret. Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: How many data points are being used in the chart? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi All....... I was given an Excel file that for some reason, every once in a while pops up this message......... "The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series" Just clicking off the message makes all appear ok. The charts do not appear to be affected, it's just aggravating for this thing to pop up randomly Any ideas how to clear it out, or how to find what's causing it? Vaya con Dios, Chuck, CABGx3 |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
32,000 Data Points?
Hi,
So what was wrong and how was it solved? This is the problem with going off line, nobody learns from the results except the two exchangers. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Bernard Liengme" wrote: Well done. Another problem solved notch on my gun <grin -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi Bernard....... Thanks, but I was just getting ready to sanitize it to send to you and the problem went away. Last night I thought I isolated the specific chart that was causing the problem and was able to produce the error message on demand, but today all is well. I cannot under any circumstances make the error message pop up. I even went back three versions of the file, all of which had the problem. I guess just the "thought" of YOU looking at it, solved the problem <g. I will keep an eye on it tho, and if the problem pops back up, I'll get back in touch. Thanks for your time, Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: I would be happy to look at the workbook. Just omit TRUENORTH. in my address best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Don't know for sure........there are 20-30 charts, just simple line charts and at first glance each appears to be ok, as far as displaying the data is concerned.......thing is, I can't make the pop-up appear on demand.....dunno why it shows up.....if I could control it, maybe I could just start deleting charts untill it goes away to find out if one of them is the culpret. Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: How many data points are being used in the chart? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi All....... I was given an Excel file that for some reason, every once in a while pops up this message......... "The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series" Just clicking off the message makes all appear ok. The charts do not appear to be affected, it's just aggravating for this thing to pop up randomly Any ideas how to clear it out, or how to find what's causing it? Vaya con Dios, Chuck, CABGx3 |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
32,000 Data Points?
Not true, the OP solved his problem; he did not say how. I just took credit
as a joking reply to his comment! -- Bernard "Shane Devenshire" wrote in message ... Hi, So what was wrong and how was it solved? This is the problem with going off line, nobody learns from the results except the two exchangers. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Bernard Liengme" wrote: Well done. Another problem solved notch on my gun <grin -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi Bernard....... Thanks, but I was just getting ready to sanitize it to send to you and the problem went away. Last night I thought I isolated the specific chart that was causing the problem and was able to produce the error message on demand, but today all is well. I cannot under any circumstances make the error message pop up. I even went back three versions of the file, all of which had the problem. I guess just the "thought" of YOU looking at it, solved the problem <g. I will keep an eye on it tho, and if the problem pops back up, I'll get back in touch. Thanks for your time, Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: I would be happy to look at the workbook. Just omit TRUENORTH. in my address best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Don't know for sure........there are 20-30 charts, just simple line charts and at first glance each appears to be ok, as far as displaying the data is concerned.......thing is, I can't make the pop-up appear on demand.....dunno why it shows up.....if I could control it, maybe I could just start deleting charts untill it goes away to find out if one of them is the culpret. Vaya con Dios, Chuck, CABGx3 "Bernard Liengme" wrote: How many data points are being used in the chart? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "CLR" wrote in message ... Hi All....... I was given an Excel file that for some reason, every once in a while pops up this message......... "The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series" Just clicking off the message makes all appear ok. The charts do not appear to be affected, it's just aggravating for this thing to pop up randomly Any ideas how to clear it out, or how to find what's causing it? Vaya con Dios, Chuck, CABGx3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| connect line to data points with missing data in between | Charts and Charting in Excel | |||
| Formatting data series - line between certain data points only | Charts and Charting in Excel | |||
| excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
| adding one same data to each of four other data points in column c | Charts and Charting in Excel | |||
| Data is added together instead of separate data points | Charts and Charting in Excel | |||
Linear Mode
