Excel Graph question for all those experts out there!?

Question

I have a bar graph showing sales over four years - months on the x-axis and rev on the y axis. I wish to show the revenue seasonality as a line over the top of this. I have created a row calculating the average then tried to use a line - Column graph but this turns one of the years into a line along with the average. I then cannot change the year back into a bar. So I have 3 columns and 2 lines instead of 4 columns and 1 line!

I am running xp and excel 2003 - hope this all makes sense!

Please help!!!

Answer 1

Right-click on the Data series you wish to change and choose the chart type. Frequently this is a much easier way than choosing one of pre-made combo charts.

Answer 2

For my posh graphs and figures, I usually cut and paste from excel into photoshop and do all the editing there. Not ideal and fairly time consuming, but you can end up with some spanking diagrams. Sorry, it's of little use I know.

Answer 3

hi, i had to make it easier to recognize approximately my adventure with the CurvyBust cream. i'm 24 years previous and that i've got spent fantastically plenty my total life wishing I had extremely larger breasts. i'm many times a length A, i might like to be a length B, fantastically as quickly as I placed on particular varieties of low decrease tops. I quite have a reliable parent, and that i admire what I quite have, yet each and every now and then i might like slightly greater. despite if I had the money, (which i do no longer simply by fact i'm a school pupil with loans to pay off), i might in no way evaluate going under the knife just to bypass up a million cup length. so as that's been my predicament. i found out approximately curvybust cream whilst i replace into flipping by (Yahoo solutions). To be honest with you, i'm no longer this sort of female who might evaluate spending funds on a cream that delivers to strengthen breast length. It in simple terms feels like an impossible factor to declare. yet there have been 3 motives that i desperate to choose for it: a million) I contacted them by skill of utilising their website simply by fact I had a query with regard to the cream being ok for delicate pores and skin (which that's, simply by fact that's made out of organic botanical components.) 2) i replace into extremely inspired by skill of their client help and willingness to describe each and every thing to me. 3) They provided me a unfastened 12 day grant without criminal duty, (I in simple terms had to pay the transport fees- I wasn't too delighted with that inspite of the incontrovertible fact that it replace into nonetheless nicely worth it to get the unfastened product). nicely, that's quite working! there's a considerable distinction interior the dimensions of my breasts! that's in easy terms been 10 days, and that they say that the authentic very final consequences won't seem until with regard to the 4-6 month time-physique, yet according to what i will see, (and what my boyfriend can feel�) there is unquestionably a distinction. My breasts are status out greater, and that they are fuller and rounder. specially situations i'm waiting to bypass out and not utilising a bra, now i will't. and that i've got a feeling that i might could desire to extremely purchase new bras if the upward thrust keeps. i'm looking forward to seeing how the subsequent month is going. There could desire to extremely be a length B in my destiny! Woohoo!

Answer 4

You could do that as a seperate chart and position it over the first when you print it out.

Answer 5

Ooer hope you got a backup of your original work.
cos u need it so you can delete the dodgy copy you now have.
you could try the edit button to undo your actions that led you there one by one. good luck.