Under Chart - #1 - #16 with a yellow line straight accross bottom 0 line.
Right - 2000 - 20000 with a pink line going up from 2000 - 18000 across the chart
Blue line with in the chart straight across the 2000 line.
Appreciate your continued support and ideas.
Tina
Thank you for the quick response.
I am still puzzled with the outcome, as I too thought it should be that easy. However, I am not getting the desired look & feel as I am needing.
Years at bottom
Line Graph in Red showing Emp # associated to the year
Line Graph in Blue showing Spent $...
Help Please. I am trying to create a multiple data Chart.
In this Chart I need to include data for years 2002 through 2009 with two lines, one showing the amount of employees in that year and the other the amount dollars spent in that year. Is this possible?
I am open to any / best...
Trying to call out in my report any section that's primary use is = "Office" to highlight the entire section.
It comes back with an error "The formula must result in a number".
Is there a way to make this convert and / or any other means to get the same result?
Thank you for your time.
Tina
Is there away to copy a formula to prevent having to create individual formulas with the same parameters except for a single word or two:
i.e.
I have Budgets & Actuals for each Month in 2008, 2009 and projections for 2010.
Current:
Formula Name - Print_August_Budget_2009...
Forgive my ignorance, but I am not sure how to add a text box within a chart and / or not clear on what you mean by a line against the column. Would this be in a text format, if so can you tell me how to do that?
I have been unsuccessful in all attempts within in Excel. Every time I try to reference the variance column, it adds either a bar or a pivot line, which is not the appearance I want.
I have now moved my graphs over to Snag It to add the text manually.
I am attempting to create a bar graph with your standard labels. In addition, I would like to add a data field without a bar representation.
Budget - Legend & Bar
Actual - Legend & Bar
Variance - Legend Only
Can anyone tell me if this is even possible?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.