Two Questions based on the same concepts:
I have a chart in excel 2007 that graphs days of the month on the X axis and Cumlative daily Percentages on the Y axis. It is line graph.
The Y axis is entered based on daily results (End of Day). I calculate what % increase there has been since the begining of the month.
Each month I have a target percentage (20%) that is to be reached by the end of the month. This is obtained from a cell on another worksheet
I would like to place a line starting @ 0,0 that goes diagonally to the target percentage by the end of the month.
So as the month goes along, I can visually see if I'm tracking above or below for a given day based on a theoretical straight line.
Can this be done?
Another chart is a bar chart that graphs Dollars per day, again input at the end of the day. On another Worksheet I have the ending dollar target for the month. How do I add a bar with a reference to another sheet that is accurate for each day? i.e. If the dollar amount for the month is $310 and there are 31 days, the first day would be $10, the second $20, The third $30....
I'm ok with VBA if it needs to be done that way. I'm used to Access and VBA there.