ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Printing point on graph in different color based on pos or neg (https://www.excelbanter.com/charts-charting-excel/31555-printing-point-graph-different-color-based-pos-neg.html)

Carol

Printing point on graph in different color based on pos or neg
 
How do I print a point on a graph in different colors based on whether the
point value is negative or positive?
Thanks,
Carol

Jon Peltier

You could make two series, one for positive points, one for negative.
It's actually less complicated than the example on this web page:

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

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


Carol wrote:

How do I print a point on a graph in different colors based on whether the
point value is negative or positive?
Thanks,
Carol



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

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