Integer i continous x-axis

[Anonymous]

Hello!

I have a problem with a continous x-axis in a bar chart... Though the x-axis presents weeks, I want to show weeks even though they don't have a value with my selections.

I get the result I want below, BUT once again, as the x-axis presents weeks, I want only valid integer weeks. I have forced the scale to an integer value in the "Number" tab in the chart properties, without a successful result.

I am using QV 11.

Thanks in advance.

/ Filip

[Anonymous]

And here is the print screen...

[narender123]

pls show your data..

[Anonymous]

No offense, but why would I need that? As you can see in the chart, there are no values for any other week than week 6 and week 8.

[Gysbert_Wassenaar · Accepted solution]

On the Axes tab set Static Step to 1 for the dimension axis.

Or add a table with all weeks

Weeks:

load recno() as Week

autogenerate(52);

And enable the options Suppress When Value Is Null for the Week dimension and disable the options Suppress Zero-Values and Suppress Missing on the Presentation tab.

[Anonymous]

Thanks, that solves the problem... what is your suggestion later in the year, when we have a lot of weeks..? A x-axis scrollbar?

[Gysbert_Wassenaar]

Yeah, a scrollbar or select a number of weeks in a listbox. Or a quarter. Whatever best fits the situation, i.e. best answers the question you created the chart to answer.

[Anonymous]

OK, thanks for your answers.

Case closed.