I know what I want but I dont know what it is called

[DexterX]

Hi there

I am looking to make a simple vertical bar chart based on a pivot table which will show me whether a numerical result this month is or worse than the previous month. I want to show and improvement on the previous month above the line and a reduction below the line. I'm guessing the line value has to be the yearly average so far or something like that but I'm not sure? I'd like to use it to identify a trend such as number of falling months in a row or improving months.

I've seen images of this before but now I am looking for it I cant find anything, would probably help if I knew what this chart type was called?

Thanks for any help
Dex

[lcartwright]

Any bar chart will do, then add in a secondary line chart to do your yearly average?

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will need to be changed.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)