Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

SSRS Chart display all Categorys

Hello Experts Exchange
I have a chart in SSRS that I'm developing, and currently it only display 3 Categories, how do I change it to show me all Categories?

Regards

SQLSearcher
0
SQLSearcher
Asked:
SQLSearcher
  • 3
  • 2
1 Solution
 
Phillip BurtonCommented:
Does your dataset only have 3 categories? Need a bit more information to help.
0
 
SQLSearcherAuthor Commented:
Hello Phillip
I have uploaded a screen shot of how the chart looks like.

I want every category labelled.

Regards

SQLSearcher
Chart-Screen-shot.jpg
0
 
Phillip BurtonCommented:
Open up Properties (press F4).

Click on the Chart Axis (which is labelled "Category A, Category B") etc. The words "Chart Axis" should be visible under the word "Properties".

Find "Interval", and type 1.

See if that works.
0
 
Phillip BurtonCommented:
Also, make sure that VariableAutoInterval" is False
0
 
SQLSearcherAuthor Commented:
Thank you very much for your help.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now