MS PPT, DataSheet for Bar Chart

Posted on 2012-09-12
Last Modified: 2012-09-16
I am using MS PPT 2003 SP3

When creating a Bar chart, I populate the
DataSheet with the following info:

        B    C     D        E      F
        One  Two   Three    Four   Five
1        20   30       40     50     60

Open in new window

When I am done I see a chart with BARS with the values on top

I do not see the row headers ('One', 'Two', 'Three', ...)

I have seen the row headers be shown at the bottom of the bar chart
before, but I can not find a way to enable that

How can I do that, what path should I take ?

Question by:Los Angeles1
    1 Comment
    LVL 24

    Accepted Solution

    If you select that row when creating your chart, Excel should use those cells for the X axis automatically.

    But you should be able to add those to a completed chart by right-clicking one of the series in your chart and choosing Select Data. In that dialog, click the Edit button under the Horizontal (Category) Axis Labels. Select the cells with the axis text (One, Two, Three, etc.), then click OK to get back to the dialog. Click OK again to close the dialog.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
    The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now