Results 1 to 3 of 3

Thread: Raw Numbers and Percentages in same chart?

  1. #1

    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.

  2. #2
    MrExcel MVP
    Join Date
    May 2003


    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 Peltier Tech Charts for Excel

  3. #3


    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