+ Reply to Thread
Results 1 to 4 of 4

Plotting chart with multiple columns

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    miami florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Plotting chart with multiple columns

    I have a previously built chart where the data was all displayed in one column for labels and one for data. I've moved the data to a different format so it's easier to read and edit. When i try to change the data source it either funks up the chart or it gives me a single cell, column or row error. I'm trying to achieve the look of the chart linked and I've added a link to the old data setup and the new data setup. I would really appreciate some guidance as to where I can find how to correct this issue.

    WorkingChart.jpg Chart working with old data format

    OldData.jpg Old data format

    NewData.jpg New data format

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Plotting chart with multiple columns

    If the chart worked with the old data layout, why not keep that too? Perhaps on a hidden sheet so nobody has to see it but it still does the trick...

    BSB

  3. #3
    Registered User
    Join Date
    02-12-2013
    Location
    miami florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Plotting chart with multiple columns

    The data has to change formats by request of the boss. Also I think I've figured out at least part of it . Using a series to grab the data and the labels separately only issue now is that the labels are all on top of each other at the bottom no spacing.

    New chart with messed up labels
    NewChart-Messeduplabels.jpg
    Last edited by theromex; 02-02-2015 at 01:52 PM.

  4. #4
    Registered User
    Join Date
    02-12-2013
    Location
    miami florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Plotting chart with multiple columns

    Figured the issue with the labels as well. Thanks anyways!

+ 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. Need help plotting multiple sets of data on same chart
    By sarkar.50 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-05-2014, 03:29 PM
  2. Macro for plotting chart on Multiple sheets
    By mrigtrishna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2012, 06:02 AM
  3. Plotting multiple series in one chart using macro
    By ziad9933 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-19-2012, 10:00 AM
  4. [SOLVED] Plotting multiple lines in Line Chart that have a very broad scale
    By NewTothisStuff in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-14-2012, 11:09 AM
  5. Pie Chart plotting 1 single color for multiple data points
    By moonseed in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-12-2008, 03:41 PM

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