PC Review


Reply
Thread Tools Rate Thread

Bar Graph Data Point alignment

 
 
Kenneth.williams
Guest
Posts: n/a
 
      8th Jul 2008
I have an embedded Bargraph from an excel workbook on a Powerpoint Slide. I
am displaying the data point value at the top of the bar. I can not get the
displayed data point values to line up so the read in a "straight line" left
to right.
 
Reply With Quote
 
 
 
 
Sandy Johnson
Guest
Posts: n/a
 
      8th Jul 2008
You have to click on each value and align them manually.

"Kenneth.williams" wrote:

> I have an embedded Bargraph from an excel workbook on a Powerpoint Slide. I
> am displaying the data point value at the top of the bar. I can not get the
> displayed data point values to line up so the read in a "straight line" left
> to right.

 
Reply With Quote
 
Echo S
Guest
Posts: n/a
 
      8th Jul 2008
I would use separate textboxes to do this because, as you have seen, there's
unfortunately no way to align the data labels.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


"Kenneth.williams" <(E-Mail Removed)> wrote in
message news:73027C50-6700-4F7F-8D57-(E-Mail Removed)...
>I have an embedded Bargraph from an excel workbook on a Powerpoint Slide.
>I
> am displaying the data point value at the top of the bar. I can not get
> the
> displayed data point values to line up so the read in a "straight line"
> left
> to right.


 
Reply With Quote
 
Andy Pope
Guest
Posts: n/a
 
      8th Jul 2008
Hi,

You may be able to use a additional data series plotted on the secondary
axis. The bars would be formatted to have no fill or border. Its data
labels would be position inside base.

Post back if you need more details. But include sample data and a
description of how/where you want the labels aligned. And the xl version.

Cheers
Andy

Kenneth.williams wrote:
> I have an embedded Bargraph from an excel workbook on a Powerpoint Slide. I
> am displaying the data point value at the top of the bar. I can not get the
> displayed data point values to line up so the read in a "straight line" left
> to right.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 
Reply With Quote
 
Echo S
Guest
Posts: n/a
 
      8th Jul 2008
Ah, yeah, I forgot about that. Duh!

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


"Andy Pope" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> You may be able to use a additional data series plotted on the secondary
> axis. The bars would be formatted to have no fill or border. Its data
> labels would be position inside base.
>
> Post back if you need more details. But include sample data and a
> description of how/where you want the labels aligned. And the xl version.
>
> Cheers
> Andy
>
> Kenneth.williams wrote:
>> I have an embedded Bargraph from an excel workbook on a Powerpoint Slide.
>> I am displaying the data point value at the top of the bar. I can not
>> get the displayed data point values to line up so the read in a "straight
>> line" left to right.

>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I draw a circle on a graph using point data and the axis? Graphically Challenged Microsoft Excel Charting 1 7th Apr 2008 06:26 PM
how to get interpolated data point values from plotted graph =?Utf-8?B?Y2FsX2hvYg==?= Microsoft Excel Charting 0 24th Apr 2006 08:45 PM
Excel should let you graph every n-th data point in a column =?Utf-8?B?d2FycmVucm9iNTA=?= Microsoft Excel Charting 3 3rd Mar 2006 08:42 PM
How can I add a caption for each data point in a bar graph? =?Utf-8?B?TGV4eQ==?= Microsoft Excel Charting 1 2nd Aug 2005 09:51 PM
Value of a data point in a graph Christian Fandel Microsoft Excel Discussion 0 26th Sep 2003 12:21 PM


Features
 

Advertising
 

Newsgroups
 


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