To improve the readability of the chart values, you might want to move the chart legend. The names on the horizontal axis are sorted from largest to smallest 2015 sales, with Zeng at the top. In the Order list, select A to Z so that the names appear in order from largest to smallest 2015 sales. By default, this list has one sort expression that is the same as the original category group expression. The Change sorting options page displays a list of sort expressions. In the Category Groups area, right-click, and then click Category Group Properties.Ĭlick Sorting. When you sort the data on a chart, you are changing the order of values on the category axis.ĭouble-click the chart to display the Chart Data pane. Change the Sort Order on the Vertical Axis If you cannot read the salesperson names on the vertical axis, you can make your chart taller or change the formatting options for the axis labels. Under Axis range and interval, in the Interval box, type 1. Right-click the vertical axis, then click Vertical Axis Properties. You can change the chart to display all categories. ![]() Display All the Names on the Vertical Axisīy default, only some of the values on the vertical axis appear. The length of the bar corresponds to the sales total. The bar chart displays sales for each sales person for the years 20. Notice the design surface gets larger as you drag. Drag the bottom-right corner of the chart to increase the size of the chart. The legend reads Last Name A, Last Name B, etc., rather than the people's names, just to give an idea of what your report will look like.Ĭlick the chart to display the chart handles. Note that the new bar chart just shows representational data. The chart is added to the design surface. SalesYear2014 represents the sales amount for each salesperson for the year 2014. The Values pane displays because the chart displays the aggregate for each product.ĭrag SalesYear2014 to the Values pane under SalesYear2015. SalesYear2015 represents the sales amount for each salesperson for the year 2015. On the Arrange chart fields page, there are four fields in the Available fields pane: FirstName, LastName, SalesYear2015, and SalesYear2014.ĭrag SalesYear2015 to the Values pane. On the Choose a chart type page, the column chart is the default chart type. (Optional) Click the Run button ( !) to see the data your chart will be based on. UNION SELECT 'Brian' as FirstName, 'Burke' as LastName, CAST(187000. UNION SELECT 'Pongsiri' as FirstName, 'Hirunyanitiwatna' as LastName, CAST(175000. UNION SELECT 'Chris' as FirstName, 'Ashton' as LastName, CAST(195000. UNION SELECT 'Michal' as FirstName, 'Jaworski' as LastName, CAST(175000. UNION SELECT 'David' as FirstName, 'Bradley' as LastName, CAST(210000. UNION SELECT 'Tanja' as FirstName, 'Plate' as LastName, CAST(150000. UNION SELECT 'Robert' as FirstName, 'Hernady' as LastName, CAST(140000. UNION SELECT 'Delphine' as FirstName, 'Ribaute' as LastName, CAST(180000. UNION SELECT 'John' as FirstName, 'Yokim' as LastName, CAST(160000. UNION SELECT 'Daniela' as FirstName, 'Guaita' as LastName, CAST(170000. UNION SELECT 'Robin' as FirstName, 'Wood' as LastName, CAST(75000. ![]() UNION SELECT 'Houman' as FirstName, 'Pournasseh' as LastName, CAST(150000. UNION SELECT 'Jeffrey' as FirstName, 'Zeng' as LastName, CAST(210000. ![]() Paste the following query into the query pane: SELECT 'Luis' as FirstName, 'Alverca' as LastName, CAST(170000.00 AS money) AS SalesYear2015, CAST(150000. On the Design a query page, click Edit as Text. For more information, see Alternative Ways to Get a Data Connection (Report Builder). You will not be getting data from the data source. The data source you choose is unimportant, as long as you have adequate permissions.
0 Comments
Leave a Reply. |