![]() |
Conditionally Format Data Points in Line Chart
I'm trying to create a Line Chart that shows one group of data, but displays
the points on the chart differently depending on the gender of each person charted. For instance each data point that is male is blue and each data point that is female is red. Here is what the data looks like: Data Gender % Color of Point on Line Chart M -7.0% Blue F -6.6% Red M -5.5% Blue F -4.0% Red F -2.5% Red F -1.0% Red M 0.0% Blue F 1.0% Red M 1.5% Blue M 2.5% Blue F 3.0% Red M 4.5% Blue F 6.0% Red I would like the % to be on the Y axis and the Gender on the X axis, conditionally formated to be blue for M and red for F. Is this possible? Thanks. |
All times are GMT +1. The time now is 07:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com