+ Reply to Thread
Results 1 to 7 of 7

Candlestick diagram showing only affected days

  1. #1
    Registered User
    Join Date
    11-24-2014
    Location
    norway
    MS-Off Ver
    2010
    Posts
    37

    Candlestick diagram showing only affected days

    Hi there!

    I want to make a candlestick diagram, but I'm not using it for stock prices. I'm using it for checking variance in earnings. But the earnings are updated very un-frequently, and not in a specific pattern. So I want a candlestick diagram that only shows the monitored days, and not every day of the month (nor etc. every fifth...)

    Is this possible to achieve?

    Note: check the attached file for more info.

    Thank you in advance!
    Attached Files Attached Files

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

    Re: Candlestick diagram showing only affected days

    This might be instructive: http://peltiertech.com/Excel/ChartsH...artTricks.html
    At one point, he says that some people don't like a date axis, so he suggests simply formatting the horizontal axis to be a category axis. Your example did not include any of your past attempts at charting this, but you might try that. Create a candlestick diagram like you had tried before, then switch the axis from Date to Text/Category.

    To my untrained eye, Candlestick diagrams just look like box and whisker diagrams. If you decide to create the diagram from scratch, you might try the "stacked column" chart formatted to be a box and whisker diagram: http://peltiertech.com/excel-box-and...ams-box-plots/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Candlestick diagram showing only affected days

    It can be done with a pivot graph.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Registered User
    Join Date
    11-24-2014
    Location
    norway
    MS-Off Ver
    2010
    Posts
    37

    Re: Candlestick diagram showing only affected days

    Quote Originally Posted by oeldere View Post
    It can be done with a pivot graph.

    See the attached file.
    Thank you again!

    Is it possible to make a candlestick diagram and not a histogram, using the pivot graph?

  5. #5
    Registered User
    Join Date
    11-24-2014
    Location
    norway
    MS-Off Ver
    2010
    Posts
    37

    Re: Candlestick diagram showing only affected days

    Quote Originally Posted by MrShorty View Post
    This might be instructive: http://peltiertech.com/Excel/ChartsH...artTricks.html
    At one point, he says that some people don't like a date axis, so he suggests simply formatting the horizontal axis to be a category axis. Your example did not include any of your past attempts at charting this, but you might try that. Create a candlestick diagram like you had tried before, then switch the axis from Date to Text/Category.

    To my untrained eye, Candlestick diagrams just look like box and whisker diagrams. If you decide to create the diagram from scratch, you might try the "stacked column" chart formatted to be a box and whisker diagram: http://peltiertech.com/excel-box-and...ams-box-plots/
    Thank you so much!

    That solved my issue!

    Appreciate it!!!

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Candlestick diagram showing only affected days

    you don't show an example so I try again.

    What is a candle stick graph.

  7. #7
    Registered User
    Join Date
    11-24-2014
    Location
    norway
    MS-Off Ver
    2010
    Posts
    37

    Re: Candlestick diagram showing only affected days

    Quote Originally Posted by oeldere View Post
    you don't show an example so I try again.

    What is a candle stick graph.
    Sorry, I should have added the diagram. I did get a pro tip on how to solve it, so it is ok now, but I have attached the file (with the candlestick diagram) just for information.

    Thank you again!
    Attached Files Attached Files
    Last edited by mariur89; 05-05-2016 at 06:46 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. [SOLVED] Excel Diagram: bubble diagram with dynamic quadrants
    By meiselsan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-27-2015, 08:26 AM
  2. Today plus 30 days is showing numbers instead of a proper date
    By enode in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-19-2014, 02:11 PM
  3. [SOLVED] showing the days passed after receiving
    By Megatronixs in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-04-2014, 09:49 AM
  4. How to build a intraday candlestick?
    By feejo in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-24-2010, 08:37 AM
  5. Excel and Candlestick Chart?
    By Mike in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-07-2006, 03:40 PM
  6. Excel & Candlestick Graphs?
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2006, 03:05 PM
  7. Excel and Candlestick Graphs!?
    By Mike in forum Excel General
    Replies: 2
    Last Post: 08-07-2006, 03:05 PM

Tags for this Thread

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