ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Change color of individual hiloline points in a series (https://www.excelbanter.com/charts-charting-excel/75398-change-color-individual-hiloline-points-series.html)

Ian

Change color of individual hiloline points in a series
 
Is it possible to have different color hilolines for different points in an
Excel chart series, in particular a stock series?

Jon Peltier

Change color of individual hiloline points in a series
 
All high-low lines in a series are formatted together. You would have to
rely on a different trick to color one line. Perhaps a two-point XY series,
with the points at the same X value and the high and low as Y values.
Similar to this trick, but with the line segment not stretching the entire
height of the chart:

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

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

"Ian" wrote in message
...
Is it possible to have different color hilolines for different points in
an
Excel chart series, in particular a stock series?





All times are GMT +1. The time now is 07:42 AM.

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