New Member
January 28, 2015
Mynda, hello, we have been communicating via email. I have tried everything I can think of to include a vertical indicator bar to show today's date. As you can see from the attached sample spreadsheet I am using inrow formula's and conditional formatting. The goal is to make the chart as simple to use as possible.
January 18, 2015
Perhaps the following example will provide a solution for you:
http://peltiertech.com/Excel/C.....Chart.html
You will see that a "Vert Line" value has been added with either #N/A or zero with that latter being used to show the current date.
July 16, 2010
Hi Bernie,
Since you weren't clear how you wanted this vertical bar to look I've made some assumptions in the attached file, and below is a link to a tutorial that teaches you how to apply conditional formats using formulas so you can learn and troubleshoot further yourself.
https://www.myonlinetraininghu.....h-formulas
There are a few tricks to highlighting a whole column/row or rang of cells based on the outcome of one formula and they are explained in the post above.
Let me know if you get stuck.
Mynda
Answers Post
1 Guest(s)