+ Reply to Thread
Results 1 to 5 of 5

conditional candle color but stacking not working and data mixed

  1. #1
    Registered User
    Join Date
    11-28-2015
    Location
    Seoul
    MS-Off Ver
    excel 2010
    Posts
    3

    conditional candle color but stacking not working and data mixed

    I am trying to create candles with condiitionally varying colors, using bars. At the moment, I am stuck with stacking or overlaying. But more serious problem(s) come from data somehow mixed. As you can see in the chart of the file attached, the x scale data is not date, indicating data is somehow mixed due to the errors in data handling with series, which is not clear to me. Thank you for your help in advance.

    In the meantime, I would appreciate other ideas to create conditional color candles instead of using conditional width and color bars.

    I am very sorry for I did not cleared all the testing junks in the macros. The only file that should have been attached is "sub 차트2()". I am very sorry for the Korean characters.

    Also, Is it not possible to cancel a post with many mistakes and repost again without mistakes? I tred to find such a function and could not find.
    Attached Files Attached Files
    Last edited by PaulHOH; 11-29-2015 at 09:48 PM. Reason: not clearing junks and Korean characters

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: conditional candle color but stacking not working and data mixed

    Which of the two charts are you referring to.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    11-28-2015
    Location
    Seoul
    MS-Off Ver
    excel 2010
    Posts
    3

    Re: conditional candle color but stacking not working and data mixed

    Oh, Sorry. It is the bar chart with red and blue colors down below. The candle chart with black and white colors is the correct one for checking. At the moment, when the bar stacking works, the bar chart should simulate the bodies of the candle chart without the tails. Since I could not change the attached file, I have attached another file with the name ConditionalColorCandleJunksCleared. There I have cleared junks and Korean characters. Very much Thankful for your reading the attached file. I would appreciate your further comments.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: conditional candle color but stacking not working and data mixed

    Hi,

    Does the attached help. It's a stacked bar chart where the low series fill colour has been set to white.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-28-2015
    Location
    Seoul
    MS-Off Ver
    excel 2010
    Posts
    3

    Re: conditional candle color but stacking not working and data mixed

    Thank you for the comment. However, the stachked bar chart you suggested seems to be made in the Excel sheet, not by executing the VBA code contained in the attached file. If you execute the code, you will find the run time error that occurs in the line for overlaying. Perhaps I did not specify what is in error. Sorry for that.
    Last edited by PaulHOH; 12-02-2015 at 04:30 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Color Scale Formatting Not Working
    By Merf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2015, 10:03 AM
  2. [SOLVED] Stacking an array of columns of data with a header
    By mxplut in forum Excel General
    Replies: 3
    Last Post: 10-17-2014, 09:57 AM
  3. Replies: 5
    Last Post: 09-24-2013, 03:42 PM
  4. [SOLVED] Excel 2007 : Conditional Formatting- Mixed Data
    By needyohelp in forum Excel General
    Replies: 20
    Last Post: 03-23-2012, 03:13 PM
  5. chart y axis is stacking...with data?
    By jeeper33 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2008, 11:32 AM
  6. Conditional Color Change Not Working
    By JohnGuts in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2008, 06:54 PM
  7. Stacking data in a comment
    By Bobby in forum Excel General
    Replies: 3
    Last Post: 11-10-2005, 12:10 PM

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