If you are getting one colour, it sounds like you do not have "¶" between the series values you are using for the chart. ( Try Slice Data of Main::Count_OffSub & "¶" & Main::Count_OnSub)
I've changed the Slice Data but i appears the same. It seems to be reading the values, just not slicing them:
My current values are:
OnSub = 4340
OffSub = 1257
If i hover my mouse over the graph, it states Value: 12574340
Do i need to somehow specify the total of clients so that the chart can then split the on and offs?
In the Chart Setup, are you specifying a Field Name or a Calculation? Based on the original post I would assume field name. Try basing it on a calculation and see if that changes anything. Also there is a "Data Source" tab on the right hand side of the chart setup. There is an option "Chart display when layout is sorted:" you can choose either "Summarized groups of records" or "Individual Record data"
I've just spent a couple of days myself trying to get a Chart to work the way I wanted it to. It took a little getting used to, but I found it usable.
The Slice Data is based on a calculation.
As for the data source, ive tried both with no change.
This layout is basically an "Admin Layout" which it linked to its own table with 1 record so there is no found set to be utilized
Try testing your calcs via the Data Viewer tool before putting them into the chart.
If the calcs are returning the correct result, that is where you need to find a fix, rather than in the chart construction.
There are really no calcs that need to be evaluated. They are already done and stored in the fields mentioned above. Perhaps i wasnt explaining the issue properly.
Using these values (which are defined as calculations i mention in first post):
Total Clients: 6256
On Sub: 4340
Off Sub: 1257
I'm basically trying to get a pie chart to visually show the user out of the total clients (6256) how many are On Sub and how many are Off Sub.
Im sure i'm missing something simple as charting is not my strong point but this is how i have the chart setup currently:
Under Data Source i have it set to Current Record (delimited data)
Create a calc which is the sum of the 3 fields, then calculate the percentage of that total for each of the other fields and chart those percentages.
Depending on the underlying table(s) from whcih you are getting your calc sums, could you do a find in the table where these records are located, sort them by group, and then just chart the resulting counts so you get 3 slices?
Charting different values in a single record is actually less simple that groupsed data in multiple records (sorted).
What Stephen is suggesting is what I ended up doing for my chart. Matt, you are doing a calculation as your field definitions. If you use the data viewer what value do you get if you have the following as your calculation in the data viewer. Calc 1 = "On sub /total Clients"
Stephen: I definately understand this being more difficult after trying it lol
pmconaway: I setup the data viewer as you suggested Main::Count_OnSub / Main::Count_Clientand the value is .6937340153452685