How to change the Size of a Legend in Crystal Report and MS Access
Steps on how to change a legend font size on Crystal Reports and text on MS ACCESS pivot charts.
Well as easy as it may seem, this sometimes proves to be a tedious task to look for. Simply because the legends functionality are not provided on the legend display area. Well enough talk and lets learn how to do that in a few steps
Obviously you are creating a graph (chart of some kind),
* Right click on the Chart Area,
* Chart Expert
* Text Tab
* On the Format Area choose Legend,
* Click the Font button
* Change the font to the your desired display
For MS ACCESS
changing the legend size does not seem to be a problem but the legend caption is.
The Simplest way to change/remove the “Sum of…” text, or any text, in a LEGEND PivotChart.
* Switch from PivotChart View to PivotTable View
* Click once to highlight the field name that reads “Sum of…”
* Go to properties
* Select the “caption” tab
* On the title “caption” type in the new text you would like
* Change the view to pivot chart
How to change the size of a legend in Crystal Report
Well as easy as it may seem, this sometimes prooves to be a tidious task to look for. Simply because the legends functionality are not provided on the legend display area. Well enough talk and lets learn how to do that in a few steps
Obviously you are creating a graph (chart of some kind),
- Right click on the Chart Area,
- Chart Expert
- Text Tab
- On the Format Area choose Legend,
- Click the Font button
- Change the font to the your desired display.
For MS ACCESS changing the legend size does not seem to be a problem but the legend caption is. I found a solution posted on http://www.tek-tips.com/faqs.cfm?fid=5491
Simple way to change/remove the “Sum of…” text, or any text, in a PivotChart LEGEND.
To change the text in a PivotChart LEGEND, switch from PivotChart View to PivotTable View. Then click once to highlight the field name that reads “Sum of…”, then go to properties, when the properties dialog box displays select the “caption” tab, now go to the item titled “caption” and simply type in the new text you would like reflected in your Legend. Switch back to PivotChart View and you will see the Legend has changed.
Read More