Excel help
Anyone in LJ-land know how to make a bar graph in Excel 2003 that include data labels for the difference between consecutive values? Right now, we make a chart for the client that shows the last three months of buzz volume for each brand. Client wants a label that shows how much the volume goes up or down every month, right at the top of each column. Now, I can calculate separately and make a bunch of text boxes, but I find the idea ridiculous. Plus, I'll have to do it that way every month. However, I can't find a way to do this automatically! Anyone? I'm willing to make a macro, and I've done some work with VBA, but nothing with charts.
ETA: Never mind, got it. Still had to make text boxes, but I was able to link them to cells, so they'll update automatically each month.
ETA: Never mind, got it. Still had to make text boxes, but I was able to link them to cells, so they'll update automatically each month.