![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
Hi there
I have a pair of financial data I was tracking over 3 years. Now I put them in a bar chart to show both values: I ended up with 3*2 bars, which is great. ![]() Now I need to highlight the growing difference between each pair over the 3 years. Is there any way I can do that? I don't want to add a 3rd bar to each pair with the difference, as it is not too big so the effect won't be too visual. However, the trend is growing: from 7% on the first year to 30% in the 3rd year. And that's what I'd like to show off. How can I do that within the same chart? Thank you, KF |
#2
|
|||
|
|||
![]()
If you're plotting vs time, you might find a line chart more effective.
Plus a line chart has the option of adding up-down bars, which draw a box from the first to the last line chart value at each X axis category (or date). These up-down bars sound like what you want to display. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 4/15/2010 8:51 AM, Krissy wrote: Hi there I have a pair of financial data I was tracking over 3 years. Now I put them in a bar chart to show both values: I ended up with 3*2 bars, which is great. ![]() Now I need to highlight the growing difference between each pair over the 3 years. Is there any way I can do that? I don't want to add a 3rd bar to each pair with the difference, as it is not too big so the effect won't be too visual. However, the trend is growing: from 7% on the first year to 30% in the 3rd year. And that's what I'd like to show off. How can I do that within the same chart? Thank you, KF |
Thread Tools | |
Display Modes | |
|
|