+ Reply to Thread
Results 1 to 3 of 3

Bar Chart Plotting Issue

  1. #1
    Registered User
    Join Date
    03-19-2022
    Location
    Nottingham, England
    MS-Off Ver
    2103
    Posts
    1

    Bar Chart Plotting Issue

    My problem is I have two sets of data, Error and Intervals, I want the Error to be plotted on the Y axis and have the Intervals plotted along the x axis. So that the Intervals correspond with the Error. For example if error is 30 at 10 intervals I would like it to display a bar chart going 30 up (on y axis) and have the 10 underneath the bar.

    At the moment I can get the error plotted but I dont have the corresponding intervals on the x axis. any help would be great.
    Thanks in advance.

  2. #2
    Registered User
    Join Date
    03-19-2022
    Location
    TBD
    MS-Off Ver
    O365
    Posts
    46

    Re: Bar Chart Plotting Issue

    Hi Dean20,

    Not sure if my understanding is correct. Have you tried right click -> Select Data, then click 'Edit' under the "Horizontal (Category) Axis Labels" ?

  3. #3
    Registered User
    Join Date
    04-30-2019
    Location
    US
    MS-Off Ver
    365
    Posts
    12

    Re: Bar Chart Plotting Issue

    To make a chart, you should have X values in one column (Error) and Y values (Intervals) in the next. Select the data and insert an XY chart. I'm not sure why you want a bar chart.

+ 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. Map Chart not plotting
    By luxy007 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-18-2018, 10:31 AM
  2. Issue with plotting a line chart
    By saahilnagrani in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-30-2018, 09:41 AM
  3. Chart Plotting
    By Joeman364 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-31-2017, 10:07 AM
  4. Having issues with plotting my data in a chart, any chart!!
    By rendalli in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-15-2015, 04:31 PM
  5. Issue with plotting a bell curve
    By carol550 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-21-2012, 10:19 AM
  6. Excel and AutoCAD plotting issue
    By cheddarthief in forum Excel General
    Replies: 0
    Last Post: 08-25-2011, 02:52 PM
  7. scatter chart insists on plotting as a line chart
    By Knows too little in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-11-2005, 03: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