• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need a Trendline Report with Two Values

N

Nikki91775

Member
I feel really silly posting this, but I have two numbers that I need to plot on a chart - YTD actual number and YTD budget (2 numbers total, i.e. 50,000 and 65,000)and I want to show how the actual number is trending on budget. If I create a bar chart, it comes up with no issues. I want this to be a line chart and I cannot get it work. Any ideas why?
 
Hi Nikki,


How can you plot line with just two numbers?? Do you need to show a straight line that moves across the chart (as standard budget)?


Regards,
 
Yes, originally that is what I wanted, but I realize it cannot be done with what I am trying to do. I have to entire values - for example the month so far are from January through April. I was just hoping to have a straight line for the budget number and then the varying line on actual.
 
Hi Nikki,


If it is just about adding a horizontal line that shows ideal budget, follow this one, it will help you:


http://peltiertech.com/Excel/Charts/AddLineHorzSeries.html


Regards,
 
You must log in or register to reply here.
Back
Top