Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a line chart with 800,000 data points | Excel Discussion (Misc queries) | |||
Line chart with Bubble data points | Excel Discussion (Misc queries) | |||
Not plotting data points in a line chart | Charts and Charting in Excel | |||
Conditionally format points based on a third column | Charts and Charting in Excel | |||
Joining data points on a line chart | Charts and Charting in Excel |