Excel - Stock Chart questions


G

Greg

How do I create a stock chart where the 'closing price' is OUTSIDE of the
High-low range?

Basically, I'm plotting sales forecasts accuracy - so I'm comparing the
final result with their high-low range. I like the stock chart format, but
can't figure-out how to plot the closing price (whisker?) outside of the range
 
Ad

Advertisements

J

Jon Peltier

At least two ways exist:

1. Change the Close series to an XY type, then format the XY series to use
the primary axis.

2. Format the Close series to plot on the secondary axis, then use Chart
Options > Axes (or the corresponding commands on the middle Chart Tools
contextual tab in the ribbon) to remove the secondary axes.

- Jon
 
G

Greg

Jon - thanks, this is very helpful - I can easily do #2.

For #1 - can you please explain how I change the Close series to an XY type?

Thanks for your help
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top