ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Horizonal Line Chart (https://www.excelbanter.com/excel-programming/339482-horizonal-line-chart.html)

Volsfan

Horizonal Line Chart
 
I have some data in three cells. A1 is the minimum value, A2 is the current
value, and A3 is the maximum value. How can I create a simple graphical
representation of the location of the current value relative to the min and
max similiar to the below


| X |
min value cur value max value

It is possible for the curr to exceed or equal either the min or the max as
it is dynamic based on entries from a lot of other cells.

Thanks in advance for any assistance.



All times are GMT +1. The time now is 10:14 AM.

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