+ Reply to Thread
Page 8 of 9 FirstFirst ... 6 7 8 9 LastLast
Results 106 to 120 of 126

Call in the Cavalry - 2017

  1. #106
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2010 (Win 7 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    10,511

    Re: Call in the Cavalry - 2017

    It may have been, but some participants might not appreciate that subtlety.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  2. #107
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    2k16(64) not4subs
    Posts
    4,101

    Re: Call in the Cavalry - 2017

    Hm, and now what I can say ?
    sandy (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  3. #108
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    8,470

    Re: Call in the Cavalry - 2017

    This OP is trying to measure volatility in what I think are investments: https://www.excelforum.com/excel-for...ml#post4732117 I don't know how volatility is measured by investors (I suggested a couple of resources suggesting standard deviation to measure volatility), but I am not sure about the suitability of this measure for his data. Anyone here know about investing and can comment?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #109
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    8,470

    Re: Call in the Cavalry - 2017

    https://www.excelforum.com/excel-cha...bar-chart.html

    I can confirm the behavior the OP describes in 2007. I don't know if it changes for other versions. Just wondering if anyone can either confirm the 100 label limit or not. Additional input would be welcome.

  5. #110
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    2k16(64) not4subs
    Posts
    4,101

    Re: Call in the Cavalry - 2017

    I added 500 labels and I can add more - bar chart (ex2k16-64)

  6. #111
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    8,470

    Re: Call in the Cavalry - 2017

    Interesting. The OP says that he is using 2016 as well. Possibly the OP is using a 32 bit version, and this limitation is due to a 32 bit version?

  7. #112
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    2k16(64) not4subs
    Posts
    4,101

    Re: Call in the Cavalry - 2017

    2013-2016
    Data series in one chart - 255
    Data points in a data series for 2-D charts - Limited by available memory
    Data points in a data series for 3-D charts - Limited by available memory
    Data points for all data series in one chart - Limited by available memory
    so if there is no limitation for points I can say - no limitation for labels

    maybe OP has 256 kb of RAM?

    2007
    Data points for all data series in one chart - 256,000

    summa summarum I added 1 000 labels for both series
    Attached Files Attached Files
    Last edited by sandy666; 08-30-2017 at 04:16 PM.

  8. #113
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    8,470

    Re: Call in the Cavalry - 2017

    I am aware of those limitations on #points/series and #points/chart, and have bumped up against them once. From my testing, it seems that this 100 labels per category axis is a separate limitation from the points/series limitation.

  9. #114
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    2k16(64) not4subs
    Posts
    4,101

    Re: Call in the Cavalry - 2017

    I don't have patience for more...
    156 series x 500 labels
    chart size: H:2500 x W:40 (cm) (ca. 984 x 16 in.)

    If you want to check this one - be my guest
    Attached Files Attached Files
    Last edited by sandy666; 08-30-2017 at 06:11 PM.

  10. #115
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    8,470

    Re: Call in the Cavalry - 2017

    You might revisit the thread. Aardigspook seems to have figured out what is going on with these category axis labels.

  11. #116
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    2k16(64) not4subs
    Posts
    4,101

    Re: Call in the Cavalry - 2017

    This confirms my thesis: OP should understand what he does
    500 axis labels
    156 series x 500 labels for values
    and it works.

    Like Aardigspook said there it depends on many factors, eg dates (horizontal - less, vertical - more) - Microsoft automation, size of chart... etc etc....

    All is well ends well
    Last edited by sandy666; 08-30-2017 at 06:44 PM.

  12. #117
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2007
    Posts
    7,428

    Re: Call in the Cavalry - 2017

    Anybody have some insight to offer here >> VBA and a Pivot Table
    HTH
    Regards, Jeff

  13. #118
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2016
    Posts
    12,102

    Re: Call in the Cavalry - 2017

    I'm stumped here. https://www.excelforum.com/excel-pro...worksheet.html

    When I run the Macro from Aug 28 sheet it errors out when it attempts to look at the Aug 21 sheet. Each sheet is identified in the code loop. Take a look at the whole issue as I have added a couple of lines of code that are not in the original.

    Thanks

    Alan

    EDIT: Solved.
    Last edited by alansidman; 09-06-2017 at 09:46 PM.

  14. #119
    Forum Guru davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    10,094

    Re: Call in the Cavalry - 2017


  15. #120
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    8,470

    Re: Call in the Cavalry - 2017

    I'm sure I can come up with a solution for this (I even posted an outline of how I would envision doing it), but I am not yet ambitious enough to put all the effort into it. https://www.excelforum.com/excel-cha...ml#post4742713

    Perhaps one of you already has a procedure worked out for what the OP wants? Or maybe you know how to use some of Excel's built in database management tools to get this result? Or maybe one of you is more ambitious than I am? Or maybe we all wait to see how far the OP gets with the outline I gave him/her.

+ Reply to Thread
Page 8 of 9 FirstFirst ... 6 7 8 9 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1