Plotting chart with multiple columns

T

theromex

New member
Joined
Feb 13, 2013
Messages
5
Reaction score
0
Points
0
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
WorkingChart.jpg

Old Data format
OldData.jpg

New Data format
NewData.jpg
 
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
 
You must log in or register to reply here.
Back
Top