If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart -- Source Data... -- Series dialog window | Sarah Jane | Charts and Charting | 2 | January 24th, 2006 10:27 AM |
How do I change a number in one cell to change a series of cells? | lance559 | General Discussion | 2 | January 13th, 2006 08:56 PM |
Charting Data Series vs. Data Points? | Tommy Z. | Charts and Charting | 4 | November 29th, 2005 11:23 PM |
How to change the color of the series markers from yellow to Black | Sam | Charts and Charting | 2 | June 30th, 2005 02:47 PM |
add vertical line to floating bar chart, still trying | bbxrider | Charts and Charting | 6 | January 27th, 2004 11:42 PM |