A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Balance Points in Excel Charts



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2009, 10:30 AM posted to microsoft.public.excel.charting
BoRed79
external usenet poster
 
Posts: 18
Default Balance Points in Excel Charts

Hi.

I regularly produce stacked bar charts to show ranges of opinions (e.g. very
poor, poor, acceptable, good and very good quality).

In these charts I often manually add a drawing shape to show a 'balance
point' (like a see-saw) - to show how opinions differ between different
groups of people.

I would like to know if there is a way to add a drawing object (or shape
etc) to a graph - but linked to data (i.e. so that it is linked to the middle
point of the data).

This would make my graphs more dynamic and would save me a lot of time
adding these shapes in manually.

Many thanks in advance for your anticipated help.

Kind Regards.

Liz.


  #2  
Old November 13th, 2009, 10:57 AM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default Balance Points in Excel Charts

Hi,

Add a series and change the chart type for this new series to xy-scatter.
You can use either the triangle data marker or a customer marker.
And use the xy values to position the marker.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BoRed79" wrote in message
...
Hi.

I regularly produce stacked bar charts to show ranges of opinions (e.g.
very
poor, poor, acceptable, good and very good quality).

In these charts I often manually add a drawing shape to show a 'balance
point' (like a see-saw) - to show how opinions differ between different
groups of people.

I would like to know if there is a way to add a drawing object (or shape
etc) to a graph - but linked to data (i.e. so that it is linked to the
middle
point of the data).

This would make my graphs more dynamic and would save me a lot of time
adding these shapes in manually.

Many thanks in advance for your anticipated help.

Kind Regards.

Liz.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.