Interactive candlestick chart

Related posts:

Use a mouse hovering technique to create an interactive chart

Interactive chart in excel (vba)

Holiday planner

Adjust stock chart axis automatically

Dynamic chart – Display values from a table row or column


Blog updates by email:

Delivered by FeedBurner

 

3 Responses to “Interactive candlestick chart”

  1. Rudy says:

    OMG, you're really genius. Thank you very much

  2. Rudy says:

    Mr. Oscar, can you help me once again, how to apply horizontal line or diagonal line based on cell value in this interactive candlestick chart so I can make target or risk reward ratio. Can we make that line in excel ? Thank you Mr. Oscar for the reply. You are the best.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Find consecutive dates in a cell range

Related posts:

How to identify two consecutive dates in a list

Most common value between two dates in a range in excel

How to find out if a number is between two dates

How to find duplicates in a range spanning multiple columns?

Find max unique value from a range that have duplicate numbers and blanks


Blog updates by email:

Delivered by FeedBurner

 

2 Responses to “Find consecutive dates in a cell range”

  1. pmsocho says:

    Very clever solution!
    Thanks for sharing.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to use FREQUENCY function

Related posts:

Return multiple values if above frequency criterion in excel

Unique distinct records sorted by frequency

Excel udf: Word frequency

Count digits and ignore duplicates in any line in excel

Use a number range when trying to find the frequency of a number in excel


Blog updates by email:

Delivered by FeedBurner

 

One Response to “How to use FREQUENCY function”

  1. Bob Watson says:

    Oscar,

    Often I see spreadsheets that have used the Histogram feature (in the Data Analysis Tools) to create a frequency distribution. Although this works, it has one major drawback: it is static. If the data changes, then the Histogram count does not update so it may be wrong.

    Using the FREQUENCY function, as you demonstrate in this article, is a much better solution.

    Cheers,

    Bob.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Highlight a data series in a line chart

Related posts:

Highlight a bar in a chart

Custom data labels in a chart

Use a map in an excel chart

Dynamic chart – Display values from a table row or column

Dynamic data labels in a chart


Blog updates by email:

Delivered by FeedBurner

 

2 Responses to “Highlight a data series in a line chart”

  1. chrisham says:

    Great Tutorial, opened a great world of Tables to be used in formulas. Drew me in to studying Table References!

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Heat map using pictures

Related posts:

Heat map calendar

Monthly time sheet by project

Analyze trends using pivot tables

Sum security holdings monthly and yearly in a pivot table

Easily identify groups of duplicate rows


Blog updates by email:

Delivered by FeedBurner

 

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.