Skipping X Axis Label Values
4 February, 2011
I have created a stacked area chart with hourly granularity over 7 days. This means 168 data points.
The problem is that the x-axis values are unreadable as shown in the attached image.
Is there any way to show just the date (rather than the hour) or have two levels of X-Axis labels e.g. date and hour?
The lookup table has the following fields
- Date
- Hour
- Timestamp (combines date and hour)
Thanks,
Michael
The problem is that the x-axis values are unreadable as shown in the attached image.
Is there any way to show just the date (rather than the hour) or have two levels of X-Axis labels e.g. date and hour?
The lookup table has the following fields
- Date
- Hour
- Timestamp (combines date and hour)
Thanks,
Michael
Hi Michael,
Apologies for the delayed response.
What is the data-type of these fields?
You should be able to create this chart and select 'time-series' which will display the points so they are readable.
Let me know how you go.
Regards,
David
Apologies for the delayed response.
What is the data-type of these fields?
You should be able to create this chart and select 'time-series' which will display the points so they are readable.
Let me know how you go.
Regards,
David
If the data set is not a time series, is there any other way to fix condensed axis labels?
I understand the difficulty when using a dimension, especially if that dimension does not have all the values in the range (e.g. in my case, if certain ages are missing).
A possible setting could be "Display 1 in every X labels" ??
Regards
I understand the difficulty when using a dimension, especially if that dimension does not have all the values in the range (e.g. in my case, if certain ages are missing).
A possible setting could be "Display 1 in every X labels" ??
Regards
Hi Samuel,
You will need to expand your chart to make the x-axis readable.
Here is an example of my report:
Now after expanding:
If this doesn't help, can you give me an example of how your table looks, as this is what is trying to plot on the chart.
Also, have you considered adding a filter to limit the results on the charts?
Thanks,
David
You will need to expand your chart to make the x-axis readable.
Here is an example of my report:
Now after expanding:
If this doesn't help, can you give me an example of how your table looks, as this is what is trying to plot on the chart.
Also, have you considered adding a filter to limit the results on the charts?
Thanks,
David
Hi David- Thanks for quick reply.
I did extend the size of the chart, which works fine when viewing the report
However, as the chart is used in a dashboard, it gets resized, and the axis labels are unreadable.
I had considered putting a filter to restrict the chart (as in most instances, there are not many records with an age above 60+).
However, this report is linked to a number of other reports on this dashboard, where the default range for the age filter is ages 0 - 100. (So I don't think I can alter the display of this chart, without affecting the filtering on all the other reports.)
I did extend the size of the chart, which works fine when viewing the report
However, as the chart is used in a dashboard, it gets resized, and the axis labels are unreadable.
I had considered putting a filter to restrict the chart (as in most instances, there are not many records with an age above 60+).
However, this report is linked to a number of other reports on this dashboard, where the default range for the age filter is ages 0 - 100. (So I don't think I can alter the display of this chart, without affecting the filtering on all the other reports.)