+ Reply to Thread
Results 1 to 2 of 2

Selectively display data in a bar chart

  1. #1
    Registered User
    Join Date
    06-07-2021
    Location
    Ohio
    MS-Off Ver
    Office 2016
    Posts
    1

    Selectively display data in a bar chart

    I would like a bar chart to show bars for only one of the underlying data points (the mean). Under the chart, I'd like to see the underlying data (item count and $ total) in addition to the mean, as numbers. When I try to add the underlying data to get it to display under the chart (in the "caption" area), it appears in the bar graph as well. I've done the same thing with a line graph, although I'm wondering now if I've just gotten lucky in the past. Any help greatly appreciated.

    (Should be a file attached but it's hard for me to tell whether it's actually there.)

    Paul
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,579

    Re: Selectively display data in a bar chart

    See if the following does what you want:
    1. Select the Monographs by Langauage chart.
    2. Select "select data" and check total and items > select OK
    3. Select one of the bars for total and select format data series
    4. Set series option to secondary axis and then set fill to no fill and border to no line
    5. Repeat steps 3 and 4 for items
    6. Select the secondary axis and set fill to no fill and set line to no line
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. selectively organize data in a table
    By eugchen in forum Excel General
    Replies: 1
    Last Post: 09-15-2019, 03:02 AM
  2. Replies: 3
    Last Post: 03-24-2016, 01:49 PM
  3. Display small chart on mouseover of another chart's data point
    By OnRope in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2013, 09:07 PM
  4. [SOLVED] How to read data from the workbook selectively?
    By billj in forum Excel General
    Replies: 18
    Last Post: 01-16-2013, 10:02 AM
  5. Selectively Plotting Data?
    By BrainFreak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2012, 05:29 AM
  6. entering data selectively
    By singht in forum Excel General
    Replies: 1
    Last Post: 10-23-2008, 05:28 AM
  7. Help w/ selectively combining data
    By bsutton19 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2005, 06:56 PM

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