+ Reply to Thread
Results 1 to 2 of 2

Using text for graphs

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    38

    Using text for graphs

    Good afternoon,

    I have attached a sample data and chart.

    The purpose of the chart is to show why production was affected on a certain day (e.g. no railcars, product quality issue, etc.)

    I would like to show this either by the acronyms charting on the graph, or even better, have the acronyms show as the vertical axis data rather than a numerical sequence. I do want to keep the series labelled as they are.

    I have tried various ways to accomplish this but to now avail.

    I do want the display to show as a scatter chart unless you think another type of chart will better convey the information. Please remember I need the data to show daily.

    Thank you so much for your assistance!

    Louise
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Using text for graphs

    Assuming I understand what you are trying to do, here's a good strategy for a chart with a "vertical category axis" https://peltiertech.com/dot-plots-microsoft-excel/ It's basically a scatter + bar combination chart where the bar chart provides the "vertical category axis" for the acronyms, and the scatter chart provides the ability to control both vertical and horizontal position.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. VBA Code to copy graphs and text to Powerpoint
    By help85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2020, 10:26 AM
  2. Replies: 1
    Last Post: 10-24-2014, 12:20 AM
  3. Graphs and Automatic Text Boxes
    By Mike5055 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2013, 11:47 AM
  4. Excel 2007 : Text in graphs changing colour randomly
    By aquitaine137 in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 05:18 AM
  5. Graphs in a text file
    By Rastabot in forum Excel General
    Replies: 1
    Last Post: 03-30-2011, 02:37 AM
  6. How to select text boxes that are in graphs
    By AussieExcelUser in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-12-2007, 11:23 PM
  7. automatically sizing text with graphs
    By Shoque in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2006, 10:35 AM

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