I have a vertical bar chart with about 130000 items (Names of Products) on the left (Y) axis and numeric values (unit sales) running on the X axis.Ã, If I run the chart as is, the graph is displayed without the Product Names text on the left axis.Ã, If I adjust the resolution height, I can get every 5th, 3rd, or 2nd one, but not all of them.Ã, My test data did not have nearly this many Product Names and worked correctly listing every Product Name on the left axis.Ã, Any ideas or suggestions to get all of the Product names to display would be greatly appreciated!
Thanks,
Don
I think a 130000 items is just to much.
Try splitting up the charts in groups or pages.
Thanks for the response - however, that is not a viable option. The user is prompted for a category. Some categories only return < 25 values. The one category I mentioned earlier returns 130000. Do you have a method for page breaking or grouping it further so a uniform number of values are displayed on each page? There is a list report at the end that lists all products, all values, and a total count. Management wants the bar graph first with all products and values displayed for the chosen product category. Any further help or suggestions would be most appreciated.
Thanks,
Don
Don,
Select the column chart and set the allow skip property to "No" Hope this helps.
Thanks for the suggestion, unfortunately it did not solve my problem (but it at least gave me something to try). I have three graphs where one has 422 products and runs fine, one had 26000+ and listed every other product. I solved it by adjusting the Resolution Height to 7000. But the third Chart with 129000+ products, its' solution remains elusive. Any further suggestions or recommendations would be greatly appreciated!
Thanks,
Don
Add a data item to your query that's defined as: rank([unit_sales]). You can make it a dimension if you want so it will display the results in order of rank, but not necessary.
Then, I would add a filter: rank > 50000 (or something). Then create as many quries as necessary to accomodate all the items. Then add a chart for each of those queries, either on the same page or different pages.
Or the user can define how many items to display (Make it a top X report). Just a suggestion.
Have you tried to adjust the page height as well?
In the category lables set the trunction property to no and set the 90 degreee rotation to yes and even set allow skip to no.
Hope this helps
Srik
From a usability perspective, a bar chart with 13,000 bars cannot possibly convey meaningful information. 1) You can't have labels because the charting tool wigs out WAYbefore 13,000 items, 2) Charts are used to visually compare things and with 13,000 items, you cannot view everything at once, 3) 13,000 items would need to be microscopically thin or span hundreds of pages.
You have a couple of options for intelligently displaying this data:
- Use a finer level of granularity for the 13,000-product category. For example, if the product category is say Vanity License Plates, then use a finer level of granularity like Vanity-License Plates:A, B, C, etc.
- Take the top x-number of items from the 13,000-product category and roll up the rest in an Other category. You can then break out the other as separate tables if you like.
- Create a threshold on your query and then use conditional formatting to show a table instead of a chart if the threshold is exceeded.
Thanks for the suggestions: I tried various settings of resolution height and was able to get to every other product name but not every product name. I hit the max on resolution height and it tells you when you have exceeded it and does not let you enter a number bigger than 32767. I tried setting the Allow Skip to No and adjusting several of the other properties, but they appear to have no effect on this problem. I have several categories that can be chosen by the user through a drop down list parameter, unfortunately, one returns 129000+ values. Some categories have considerably less (less than 500). Management wants all of the reports that come from this prompt page to appear the same. At present, management wants a bar graph with the product name on the left and the bar and value going to the right with some grid lines. This is followed by a list report of the same data. They want the whole graph to appear on one html page and the length of the page does not matter to them. All of this is per the requirements agreed upon by my management and the customer. So, for right now, management wants me to fix it quickly while they negotiate further improvements in the reports with the actual customer. Any other suggestions or advice would be greatly appreciated.