Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bart chart with lines showing % change between elements
I have 5 sets of data, each with a before and after amount that has been
charted using a simple bar chart. Is it possible to have excel, using a line from the before element to the after element, show the % change between the two? I can easily calculate the percent change between the two, but if I graph it and set it to a line, the only way it can be seen is if I chart it on an alternate axis. Further, I just want a line from the top of the before element to the top of the after element, and a label showing the % change. Confused? Hope not :) Thanks for any help! |
#2
|
|||
|
|||
I might be tempted to do this as a waterfall chart instead of a line
chart. A floating column shows the amount of difference between before and after. You can put custom labels into the floating columns to show percentages. http://peltiertech.com/Excel/Charts/Waterfall.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tom wrote: I have 5 sets of data, each with a before and after amount that has been charted using a simple bar chart. Is it possible to have excel, using a line from the before element to the after element, show the % change between the two? I can easily calculate the percent change between the two, but if I graph it and set it to a line, the only way it can be seen is if I chart it on an alternate axis. Further, I just want a line from the top of the before element to the top of the after element, and a label showing the % change. Confused? Hope not :) Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create vertical lines in a line chart? | Charts and Charting in Excel | |||
Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel | |||
Lines not visible in an Excel line chart | Charts and Charting in Excel | |||
= Drawing more lines in a OHLCV chart = | Charts and Charting in Excel |