We help IT Professionals succeed at work.
Get Started

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

GNOVAK asked
Last Modified: 2012-05-09
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.

Watch Question
Most Valuable Expert 2011
Awarded 2010
This problem has been solved!
Unlock 2 Answers and 9 Comments.
See Answers
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

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

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

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE