+ Reply to Thread
Results 1 to 3 of 3

Adding additional Values to a Bar chart

  1. #1
    Registered User
    Join Date
    12-01-2013
    Location
    Sydney, australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Adding additional Values to a Bar chart

    Hi everyone,

    I am often updating a number of chart bars in PowerPoint which require to show the data label as well as other data outside the chart but that needs to be displayed next to a specific data field, and more importantly, exactly aligned on the right hand side.

    I have attached an example of what I mean - sorry is in a zip file, it won't let me upload PowerPoint files for some reason. Right now as you can see I'm using text fields (for the PCYA) and playing around with spacing to align those figures, but as you can imagine it is very time consuming.

    Does anyone know how to do that by selecting all the data or any shortcut?

    Thanks in advance,
    Ivan
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-16-2013
    Location
    Oklahoma City, OK
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Adding additional Values to a Bar chart

    First, I have not looked at your attachment, but have you considered putting your data into a table, then creating a pivot chart off the data? The data should be able to update fairly easily, and the format should hold. Once refreshed, you could copy it into another program. I do this on a regular basis and it updates easily for me, and keeps the format.

  3. #3
    Registered User
    Join Date
    12-01-2013
    Location
    Sydney, australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Adding additional Values to a Bar chart

    Hi Jemmers,

    Thanks for your feedback. The issue is more to do with how to align additional data with a bar chart than updating the data. If you look at the charts you'll see the charts are very basic, it's an alignment issue.

    Thanks
    Ivan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding additional source data to a chart
    By Mavis Cruet in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 10-21-2011, 03:51 AM
  2. Adding additional columns and values based on the given data
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2011, 05:22 PM
  3. Replies: 4
    Last Post: 02-04-2011, 05:08 AM
  4. Replies: 1
    Last Post: 03-20-2009, 04:56 PM
  5. Adding additional data to a pivot chart
    By zasskar in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-05-2006, 04:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1