ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Provide a "high/low" chart (stock chart) in horizontal mode (https://www.excelbanter.com/charts-charting-excel/68021-provide-high-low-chart-stock-chart-horizontal-mode.html)

Horizontal high/low chart

Provide a "high/low" chart (stock chart) in horizontal mode
 
An ability to provide a "high/low" chart similar to a stock chart in a
horizontal mode would provide an ability to compare values in a minimum and
maximum mode. For example, nonlethal weapons have a minimum safe distance
and a maximum effective range. Reaction times have a minimum cognition time
and a maximum response time.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Andy Pope

Provide a "high/low" chart (stock chart) in horizontal mode
 
Hi,

Whilst not a built-in chart is this what you need.
http://peltiertech.com/Excel/Charts/BoxWhiskerH.html

Cheers
Andy

Horizontal high/low chart wrote:
An ability to provide a "high/low" chart similar to a stock chart in a
horizontal mode would provide an ability to compare values in a minimum and
maximum mode. For example, nonlethal weapons have a minimum safe distance
and a maximum effective range. Reaction times have a minimum cognition time
and a maximum response time.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Jon Peltier

Provide a "high/low" chart (stock chart) in horizontal mode
 
For a real simple example, try this:

http://peltiertech.com/Excel/Charts/HorizontalHLC.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Andy Pope" wrote in message
...
Hi,

Whilst not a built-in chart is this what you need.
http://peltiertech.com/Excel/Charts/BoxWhiskerH.html

Cheers
Andy

Horizontal high/low chart wrote:
An ability to provide a "high/low" chart similar to a stock chart in a
horizontal mode would provide an ability to compare values in a minimum
and maximum mode. For example, nonlethal weapons have a minimum safe
distance and a maximum effective range. Reaction times have a minimum
cognition time and a maximum response time.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I Agree" button in the message pane. If you do not see the button,
follow this link to open the suggestion in the Microsoft Web-based
Newsreader and then click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com