Chart: x-Axis with clustered/dynamical legend

[Anonymous]

Hi,

in a chart there to many values on x-axis. First value of chart is GJ_Woche 2010/01. How can I display the x-axis like attached pic?

2010/01, 2011/01, 2012/01,... Can this legend also define dynamical?

Regards

Stefan

[hic]

You need to create your GJ_Woche so that it is numeric, e.g. by using

  Dual(WeekYear(Date) & '/' & Week(Date), WeekStart(Date) ) as GJ_Woche

Then you need to set the axis to be "Continuous" in the graph. (Properties - Axes)

HIC

[#3]

Hi Stefan,

If you need x-axis values to be  exactly horizontal, you should follow what Henric has mentioned.

But if you are fine with the values being displayed vertically or little slanted then you can right click on chart, go to Properties--Axes tab. Then in the Dimension Axis section, you can change the "Primary Dimension labels" to "|" or "/" as required.

Hope this helps!

[sunilkumarqv]

For simplicity change Primary Dimension labels For more over script you need to put efforts