Excel Graphs 1

[TinaReif]

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?

 

[GlennUK]

What have you tried so far?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[TinaReif]

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.

 

[AnotherHiggins]

You could just add a Text Box. Or you could show the variance as a line against the columns.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[TinaReif]

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?

 

[buitenhek]

Budget (100), Actual (80), Variance 20
Col 1 Column 2
Budget 100
Actual 80
Variance (20) blank

Highlight the 2 columns and go into Source Data Series - rows.
Draw Graph (it has 3 bars and 3 legends)
Highlite and right mouse click over Variance bar to make the color same as background and remove outline. Now the bar is invisible and Variance (20) shows up in the legend.

For a changing Variance you might try
=CONCATENATE("Variance (",F3,")") where F3 is the variance value and 3A is the variance info cell

I do like Snag It also.



Regards
Peter Buitenhek
ProfitDeveloper.com

 

[TinaReif]

This worked great - thank you.