We help IT Professionals succeed at work.

# How to graph a fixed line vs individual days data in Excel

on
631 Views
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.

Comment
Watch Question
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
This problem has been solved!
###### Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

Deciding to stick with EE.

Mohamed Asif

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant