Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 15th 10, 01:51 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 22
Default Drawing attention to difference in bar chart

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   Report Post  
Old April 16th 10, 01:12 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 461
Default Drawing attention to difference in bar chart

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drawing a line on a chart ExcelGeek75 Charts and Charting in Excel 4 March 12th 10 01:00 PM
Drawing shapes in a chart ChadTarget Charts and Charting in Excel 1 September 21st 06 09:07 AM
Drawing on a chart Steve Excel Worksheet Functions 2 June 8th 06 01:28 AM
Drawing a line in bar chart Julien Charts and Charting in Excel 1 January 6th 06 10:13 AM
= Drawing more lines in a OHLCV chart = hcova Charts and Charting in Excel 1 December 13th 04 04:57 AM


All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017