Home |
Search |
Today's Posts |
#1
|
|||
|
|||
identifying current month
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? |
#2
|
|||
|
|||
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" wrote in message ... 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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current Month Query | Excel Worksheet Functions | |||
Add one month to the previuos month | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
UserForm to select current month or earlier | Excel Discussion (Misc queries) |