If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2-D charting with multiple rows
I have a power user who wishes to increase the size of his 2-D graphics but
is limited to using 32000 records. He needs to be able to use 64,000 records. Any suggestions? I think this might be something that is changed in regedit but I am not sure. Thanks! |
#2
|
|||
|
|||
Yep, and you can bypass the 256 column limit with Windows API calls.
Joking aside, how about two series, formatted identically. If you have duplicate entries in the legend, select the legend, then select the text of one entry, and press the Delete key. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KathyM wrote: I have a power user who wishes to increase the size of his 2-D graphics but is limited to using 32000 records. He needs to be able to use 64,000 records. Any suggestions? I think this might be something that is changed in regedit but I am not sure. Thanks! |
#3
|
|||
|
|||
Thanks Jon. I'll pass this information on to the user. I don't work with
charts but I'll let you know if this is what he is looking for. Thanks!!!! "Jon Peltier" wrote: Yep, and you can bypass the 256 column limit with Windows API calls. Joking aside, how about two series, formatted identically. If you have duplicate entries in the legend, select the legend, then select the text of one entry, and press the Delete key. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KathyM wrote: I have a power user who wishes to increase the size of his 2-D graphics but is limited to using 32000 records. He needs to be able to use 64,000 records. Any suggestions? I think this might be something that is changed in regedit but I am not sure. Thanks! |
#4
|
|||
|
|||
He says that:
That is sort of what I am doing now. I have run up against the wall because I have so many numbers and rows of data. Any other ideas anyone??? Thanks! "KathyM" wrote: Thanks Jon. I'll pass this information on to the user. I don't work with charts but I'll let you know if this is what he is looking for. Thanks!!!! "Jon Peltier" wrote: Yep, and you can bypass the 256 column limit with Windows API calls. Joking aside, how about two series, formatted identically. If you have duplicate entries in the legend, select the legend, then select the text of one entry, and press the Delete key. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KathyM wrote: I have a power user who wishes to increase the size of his 2-D graphics but is limited to using 32000 records. He needs to be able to use 64,000 records. Any suggestions? I think this might be something that is changed in regedit but I am not sure. Thanks! |
#5
|
|||
|
|||
Kathy -
Is it meaningful to show 64000 records? A chart that's 200 x 320 has that many pixels. Could the data be decimated or averaged or somehow beaten into submission? I know data's important, but showing too much all at once prevents it from the transition from data to information to knowledge. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KathyM wrote: He says that: That is sort of what I am doing now. I have run up against the wall because I have so many numbers and rows of data. Any other ideas anyone??? Thanks! "KathyM" wrote: Thanks Jon. I'll pass this information on to the user. I don't work with charts but I'll let you know if this is what he is looking for. Thanks!!!! "Jon Peltier" wrote: Yep, and you can bypass the 256 column limit with Windows API calls. Joking aside, how about two series, formatted identically. If you have duplicate entries in the legend, select the legend, then select the text of one entry, and press the Delete key. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KathyM wrote: I have a power user who wishes to increase the size of his 2-D graphics but is limited to using 32000 records. He needs to be able to use 64,000 records. Any suggestions? I think this might be something that is changed in regedit but I am not sure. Thanks! |
#6
|
|||
|
|||
I talked briefly with him and he was trying to cut down on the number of work
sheets that he uses to develop the charts and graphs. From what I understand he has given up on consolidating this information and will continue to use numerous workbooks and worksheets as he is now doing. Thanks for trying to assist! "Jon Peltier" wrote: Kathy - Is it meaningful to show 64000 records? A chart that's 200 x 320 has that many pixels. Could the data be decimated or averaged or somehow beaten into submission? I know data's important, but showing too much all at once prevents it from the transition from data to information to knowledge. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KathyM wrote: He says that: That is sort of what I am doing now. I have run up against the wall because I have so many numbers and rows of data. Any other ideas anyone??? Thanks! "KathyM" wrote: Thanks Jon. I'll pass this information on to the user. I don't work with charts but I'll let you know if this is what he is looking for. Thanks!!!! "Jon Peltier" wrote: Yep, and you can bypass the 256 column limit with Windows API calls. Joking aside, how about two series, formatted identically. If you have duplicate entries in the legend, select the legend, then select the text of one entry, and press the Delete key. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KathyM wrote: I have a power user who wishes to increase the size of his 2-D graphics but is limited to using 32000 records. He needs to be able to use 64,000 records. Any suggestions? I think this might be something that is changed in regedit but I am not sure. Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating multiple rows of data from a Quantity value in a table | Doug R | General Discussion | 2 | October 17th, 2004 09:07 PM |
Creating multiple rows of data from a Quantity value in a table | Doug R | Running & Setting Up Queries | 11 | October 16th, 2004 04:43 AM |
Comparing Multiple Columns and Rows | Anthony | Worksheet Functions | 2 | October 4th, 2004 09:13 PM |
Inserting multiple rows into a table while maintaining data? | JAnderson | General Discussion | 2 | July 8th, 2004 05:45 PM |