I am working with finance data which I put into line graphs. Is there anyway
to identify the current month without having to manually put in and move a
line in 30plus graphs?
I am working with finance data which I put into line graphs. Is there anyway
to identify the current month without having to manually put in and move a
line in 30plus graphs?
Let me make sure I understand what you want. Before I answer any further,
do you want all months on the graph, but you want the current month to look
different on the graph? If that's the case, I'd create two columns of data
for the chart.
Column A - Date Information
Column B - Financial Data
Column C - Current month data
Column D - Non-current Month Data
Enter in C3
=IF(MONTH(A3)=MONTH(TODAY()),B3,NA())
Enter in D3
=IF(MONTH(A3)<>MONTH(TODAY()),B3,NA())
This should get you started.
Have a great day!
Barb Reinhardt
"Sue" <[email protected]> wrote in message
news:[email protected]...
>I am working with finance data which I put into line graphs. Is there
>anyway
> to identify the current month without having to manually put in and move a
> line in 30plus graphs?
Sue -
Another way, if you wanted an actual line, is to follow one of these
techniques, using a variation on Barb's formulas to determine where the
line should be positioned.
http://peltiertech.com/Excel/Charts/AddLine.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Sue wrote:
> I am working with finance data which I put into line graphs. Is there anyway
> to identify the current month without having to manually put in and move a
> line in 30plus graphs?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks