+ Reply to Thread
Results 1 to 1 of 1

Updating existing 4 line graph is giving single line graph

  1. #1
    Registered User
    Join Date
    09-04-2009
    Location
    Gloucestershire, England
    MS-Off Ver
    Excel 2010
    Posts
    45

    Unhappy Updating existing 4 line graph is giving single line graph

    I have existing charts in a spreadsheet using staggered data that are fine, but when I update the chart after adding new data it is changing from 4 single lines to 1 single long line and no matter how many times I change the information in the 'Select data' icon it keeps putting into a single line. Does anyone know why? or what I can do to get over this problem?
    An example of my existing chart is attached. The chart on the left is how I want it to look and how it looked previously. The chart on the right is what I am now getting from the same data table.
    The table of data is below. I want to use the figures in column I (but only the positive values - greater than zero). When I did the first charts I went into the 'Select chart data' icon, in the chart data range I selected the sets of data in column I that I wanted (for 2011/2012 I need all 5 rows in column I for that year, for 2012/2013 I want the first 4 rows in column I for that year, for 2013/2014 I want the first 3 rows in column I for that year etc etc). I used the control button to select each set of data. I then went into the 'Legend Entries (Series) area and selected the cells containing the financial year names individually, and then into the Horizontal Category to select cells B28:B32 to give the values year1, year2, etc.
    This worked on numerous charts but when I update any of the figures now it is changing to a single line as in the graph on the right and I cannot seem to get it to change.
    Attached Files Attached Files

+ 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. [SOLVED] Line Graph from a single live cell?
    By sherman51 in forum Excel General
    Replies: 6
    Last Post: 09-11-2015, 05:57 AM
  2. Single line graph from hamster data
    By greenwood in forum Excel General
    Replies: 8
    Last Post: 04-17-2015, 09:05 AM
  3. Colouring of single line graph
    By taniakoshi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-03-2012, 08:12 AM
  4. Add secondary column graph to existing line graph
    By nbuk in forum Excel General
    Replies: 8
    Last Post: 09-02-2010, 11:49 AM
  5. Add mountain graph to existing line chart
    By cooper1308 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-01-2010, 03:58 AM
  6. Updating Line Graph
    By landmarkvalue in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-21-2007, 02:11 PM
  7. [SOLVED] plotting a single line graph
    By plotting graphg in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-28-2005, 07:30 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