+ Reply to Thread
Results 1 to 3 of 3

Charts - Lining up one data series with another

  1. #1
    Registered User
    Join Date
    12-12-2006
    Posts
    17

    Charts - Lining up one data series with another

    Hello all,

    I've got some school data in Excel for 5 subjects and we can create a bar chart of this data no problem. The problem is we need to also display (as a line or points) Lancashire data on top of the bars. I've added another data series but cannot get the points to tie up with the subjects - they all just appear in the middle.

    It treats the Lancashire data as a seperate subject altogether.

    This is best shown as an example so please see attached file file to demonstrate this in Sheet1.

    Have we set the data up incorrectly? Many thanks for any help.
    Attached Files Attached Files
    Last edited by VBA Noob; 11-03-2008 at 09:18 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,127
    Have a look at Jon's examplanation of how to get the lines in the center of the column rather the cluster.
    http://peltiertech.com/Excel/Charts/...olAndLine.html
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-12-2006
    Posts
    17
    That's excellent Andy, it's exactly what I was after.

    Many many thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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