Results 1 to 2 of 2

Clustered bar chart with one group showing as a symbol

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2015
    Location
    Calgary, Canada
    MS-Off Ver
    Office 2013
    Posts
    1

    Clustered bar chart with one group showing as a symbol

    Hi,

    I'm trying to create a combination chart in some ways.

    I have data that looks like the following:

    Country	2013	2014	Historical Average
    Canada	8	9	8
    US	4	6	7
    Portugal	5	7	2
    Spain	4	5	3
    Brazil	7	8	6
    Australia	9	10	9
    India	4	5	7
    China 	3	4	4
    Japan	7	8	7


    I'm trying to create a clustered bar chart where the bars run horizontally and the historical average shows as a symbol on the chart instead of another bar.

    I've tried selecting the series and adding as scatter plot but then the points aren't aligned correctly. I have Excel 2013. The attached excel file shows what I want the graph to look like where I've modified the error bar to show the symbol, but I'd like to customize the symbol if possible.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Group data within chart showing individual records
    By valleysboy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-30-2013, 10:49 AM
  2. Clustered Bar Chart
    By syswizard in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2012, 01:45 PM
  3. Replies: 0
    Last Post: 03-02-2012, 12:54 PM
  4. Replies: 1
    Last Post: 09-09-2009, 05:53 AM
  5. Replies: 1
    Last Post: 10-08-2008, 11:26 AM

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