F
Formatting
Can I do a conditional formatting on a chart?
Let assume I have a stream of 10 stock prices and plotted them on a chart as
dots.
What I would like to see is that if the price for a given day is higher than
the previous day, show the dot in blue.
If the price is the same as the previous day's price, show the dot in black,
and red if the price is lower than previous day's price.
How do I go about formatting the chart to show a string of 10 dots in
combination of blue, black and red?
Let assume I have a stream of 10 stock prices and plotted them on a chart as
dots.
What I would like to see is that if the price for a given day is higher than
the previous day, show the dot in blue.
If the price is the same as the previous day's price, show the dot in black,
and red if the price is lower than previous day's price.
How do I go about formatting the chart to show a string of 10 dots in
combination of blue, black and red?