Results 1 to 3 of 3

Thread: Plotting chart with multiple columns

  1. #1

    Plotting chart with multiple columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

    Working Chart
    Click image for larger version. 

Name:	WorkingChart.jpg 
Views:	13 
Size:	58.9 KB 
ID:	3119

    Old Data format
    Click image for larger version. 

Name:	OldData.jpg 
Views:	4 
Size:	58.0 KB 
ID:	3120

    New Data format
    Click image for larger version. 

Name:	NewData.jpg 
Views:	4 
Size:	88.8 KB 
ID:	3121

  2. #2
    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
    Click image for larger version. 

Name:	NewChart-Messeduplabels.jpg 
Views:	2 
Size:	57.5 KB 
ID:	3122

  3. #3
    Well never mind, figured that issue as well!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •