Board 8 > Need Excel help - charts

(+) Yeah! (+)

I'm trying to chart percentage changes for a number of out of target lists. I've got this idea that I'll plot the starting percentage and the current percentage, then label each list with the change in percentage. I've got something that doesn't quite look like what I want (a scatter plot with different icons for the start, current, and change percentages), but it's sort of on the way there.

I haven't been very successful trying to find an answer with Google. Does anyone know if there's an Excel chart that does what I want?

I don't understand

Tag so I remember to come back to this tomorrow

Can you give me a few example columns as far as what the raw data will consist of and perhaps a rudimentary paint image of how it should look?

i'm not 100% sure if I'm understanding the question but it sounds exactly like this solution I whipped up for someone recently:
https://gamefaqs.gamespot.com/a/user_image/4/1/9/AANp2HAAEljz.png

https://gamefaqs.gamespot.com/a/user_image/4/2/0/AANp2HAAElj0.png

https://gamefaqs.gamespot.com/a/user_image/4/2/1/AANp2HAAElj1.png

I didnt do a good job of explaining this. It makes sense in my head, but I dont know if Excel has what I want.

Imagine you have three values: a starting value, an ending value, and the difference between the two. I want to chart the starting value and the ending value, and I want a label that shows the difference. Its sort of like the stock open/close charts, but a little more basic.

Stacked bar chart and then set the part of the bar from 0 to the min value to be no colour/transparent. So the visible bar chart would show the "difference" between the starting and ending values which would be the bottom and top of the bar and the label for that bar would represent the difference amount.

How to also get labels on there also showing the starting and ending values... that's probably needing a second chart on a secondary axis using the same scale.

Steiner's reco is also pretty good especially if you want to show percentage rather than absolute value differences.

(like 20 years of using Excel and I'm still terrible at making charts, lol...)

MartinFF7 posted...

So the visible bar chart would show the "difference" between the starting and ending values which would be the bottom and top of the bar and the label for that bar would represent the difference amount.

I just went about making a scatter with lines that did this and duhhh this is a much more elegant way to do it. but yeah, you'd have the issue with start/end, so I think separate bars is the better way in the end.