Thx for that working example. You must have a good way to pull data out of pics…
Now, I’m feeling my way here. But, it looks like maybe DataRange must ALWAYS be defined (one way or another). Is that right? I’m afraid I see no functional reason for that, which makes it hard to parse. Below is my Series dialog which shows why I’m asking this question.
Originally I thought DataRange for my data was supposed to be one single block which contained everything; that’s what I (mis) understood from reading the docs several times. That resulted in Series which didn’t make any sense to me. So I went straight to defining the Series for X and Y and that looked like it should work, but no.
Here is what I tried and came up empty as in my 1st post:
Here is how I thought DataRange was meant to be defined:
Here’s what then displayed in Series after defining all source data in one DataRange as I thought was asked for:
Which is what led me to try to define Series directly. I find this very confusing as the data and setup info required for an X/Y chart seem to be wholly defined by my Series ranges - and yet it doesn’t work.
Which leads me to ask: What is the point of the DataRange entry if it essentially gets duped and reworked in the Series entry? I’m trying to find a functional trail using the tools (dialogs) offered by Chart, an understanding of how the pieces fit together, which will aid in applying this effort down the road in more realistic situations.
Thx,
Rufus
