+ Reply to Thread
Results 1 to 2 of 2

Type of chart

  1. #1
    Registered User
    Join Date
    02-06-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    1

    Exclamation Type of chart

    Screenshot 2019-04-02 at 8.47.05 PM.png
    What kind of chart is this?? Can you also elaborate applications,usage etc????

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Type of chart

    You can produce such card using XY (scatter) plot.
    Attached file contains 4 steps:
    1) both series (on X values for 2016 and 1017 respectively, on Y 1;2;3...)
    2) added horizontal error bars with custom values (calculated as difference between 2017 and 2106 value)
    3) added labels for second series, source - custom cells (If I remember it ios also available in Excel 2013 if not, you can use free add-in: http://www.appspro.com/Utilities/ChartLabeler.htm
    4) deleted vertical axis labels and ticks.

    Of coures then you could do some additional formatting - add axis and/or chart title(s), remove horizontal grid lines, change labels font and color etc.

    See file
    Attached Images Attached Images
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. Pivot Combo chart - retain chart type for specific data series
    By meileetan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-21-2019, 03:48 AM
  2. [SOLVED] Radar Chart - series chart type conversion issues
    By Prince Dakkar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-20-2015, 08:44 AM
  3. Replies: 3
    Last Post: 01-02-2014, 07:56 AM
  4. Replies: 1
    Last Post: 06-14-2011, 09:50 AM
  5. How do I stop Pivot Chart changing chart type by itself?
    By lealea1982 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-03-2008, 07:49 AM
  6. [SOLVED] Pivot Chart: cannot apply the default chart type...
    By doco in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2005, 01:06 PM
  7. Adding a line Chart Type to a stacked-clustered Chart Type
    By Debbie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2005, 08:06 PM

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