Chart Not acting as you would expect

[techtony]

This may just be me missing something very simple, and if it is, then I apologize for my ignorance ahead of time.

I am creating a Chart from a query. This query is as follows:

SELECT
Phases.phase_name,
Count(Refresh_Tickets.refresh_id) AS phase_cnt
FROM
Refresh_Tickets
LEFT JOIN
Phases
ON
Refresh_Tickets.refresh_current_phase = Phases.phase_id
WHERE
(((Refresh_Tickets.refresh_scheduling_group)=[TempVars]![schgrpID]))


GROUP BY
Phases.phase_name;

This query produces the following:





Which has the group name, and a total - perfect! Now I just want to make a chart for it.

When I try to create a chart, The chart basically shows what you want, but there is a strangely name total variable that it puts as a label - there is not way to change this or change the color of each of the bars? Am I missing something?

[June7]

I deal with graphing issues best when I can work with data. If you want to provide db, follow instructions at bottom of my post.

[techtony]

Here is the database. There is one thing I wish you could help with as well since you have my database. Notice on the main menu form that the font and colors and other formatting is plain. BUT it is not supposed to be like that. Open a form, and go to formatting - you will notice that the font and size and bold are shown correctly in the ribbon,but NOT reflected on the form itself. Now - if you take the font size and increase it or decrease it a bit - you will notice that the form element then reflects the formatting. If you save the database and go back in - the changes are all lost and you have to re- do the entire forms formatting. Not sure how to resolve that either.

The query that displays the chart information is the "Count Query"

[June7]

Is that form "Main Navigation"? Not getting the format issue.

I don't see any form or report with a chart. Should provide what you attempted.

The query uses a TempVars variable for filter criteria. Where is the variable set?

[techtony]

Is that form "Main Navigation"? Not getting the format issue.

I don't see any form or report with a chart. Should provide what you attempted.

The query uses a TempVars variable for filter criteria. Where is the variable set?

Oops - sorry about that. The chart report I must have got ticked off and deleted it I basically used the report insert chart wizard.

As for the temp var - the variable is set when you use the employee login form. The variable is gathered from the Scheduling Group Table.

[techtony]

And yes the main navigation form is the one with the issue. This is what we get when we open it -



And this is what it is supposed to look like -

[June7]

Odd, I get the first on my office computer but the second on my home laptop (will double-check tonight). However, in both cases the properties and the ribbon both say Arial Black 11. Never encountered this before. These settings hold:

Font: Arial
Size: 11
Weight: Bold

Maybe rebuild the form.

Have you tried viewing on different computer?

What kind of chart do you want? Really should post version with your attempt so I have something to analyse.

[techtony]

I will re-do the chart and zip it up for you to see - sorry about that - really I thought it was there. I just did the report builder - nothing fancy, just the simple bar chart was all. But the form issue is odd indeed. I guess I can dump the front end entirely and start over, but just seems like a lot of work just to get this to work correctly. I will get started on that this weekend

[June7]

The issue seems to be with the one form. Try just rebuilding it only.