Results 1 to 3 of 3

Raw Numbers and Percentages in same chart?

This is a discussion on Raw Numbers and Percentages in same chart? within the Excel Questions forums, part of the Question Forums category; I was wondering if there is any way to create a chart that has columns representing raw numbers, but then ...

  1. #1
    New Member
    Join Date
    Apr 2005
    Posts
    11

    Default Raw Numbers and Percentages in same chart?

    I was wondering if there is any way to create a chart that has columns representing raw numbers, but then select Data Table and have the percentages displayed?
    I know how to create a combination chart, but the format that is desired for this report is to show numbers and percents together in the same graph if possible.
    Thanks!

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    3,690

    Default

    You could add the percentages as a new series, change it if necessary to a line series, then hide it by formatting it to have no lines and no markers. This will appear in the data table.

    Or you could build a custom data table, either in the cells near the chart, or in any range somewhere else. You can add any information you want, and format it however you want. Then use the camera tool to copy the table and place it where you want it.

    The camera tool button can be added to a toolbar like this: Tools menu > Customize > Commands tab, choose Tools in the left hand list, find the Camera tool on the right, and drag it to a convenient place in the toolbars.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try the Peltier Tech Chart Utility

  3. #3
    New Member
    Join Date
    Apr 2005
    Posts
    11

    Default

    Thanks, I'll give your suggestions a try!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com