| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format alignment for XLS 2007 in the chart data
I have a chart with the chart data displayed. However, it did not show the
full figure (19576.35 was shown as 195) due to the size of the chart. How can I format the digit figure to vertical in order to show all the digits. Thank with Regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format alignment for XLS 2007 in the chart data
Presumably these are the horizontal axis tick labels?
Select the axis or its tick labels and press CTRL+1 (numeral one) to open the Format Axis dialog. Click on the Alignment button on the left side of the dialog, then choose one of the options in the Text Direction dropdown. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "vcff" wrote in message ... I have a chart with the chart data displayed. However, it did not show the full figure (19576.35 was shown as 195) due to the size of the chart. How can I format the digit figure to vertical in order to show all the digits. Thank with Regards |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format alignment for XLS 2007 in the chart data
Thanks for your reply.
No, I am refering to the DATA TABLE below the chart. I am able to see the complete figure (19576.35) unless I expand the chart to the right. However, I wish to maintain only a small chart on the worksheet. Any help will appreciated. Tnks "Jon Peltier" wrote: Presumably these are the horizontal axis tick labels? Select the axis or its tick labels and press CTRL+1 (numeral one) to open the Format Axis dialog. Click on the Alignment button on the left side of the dialog, then choose one of the options in the Text Direction dropdown. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "vcff" wrote in message ... I have a chart with the chart data displayed. However, it did not show the full figure (19576.35 was shown as 195) due to the size of the chart. How can I format the digit figure to vertical in order to show all the digits. Thank with Regards |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format alignment for XLS 2007 in the chart data
These data tables are pretty inflexible. I generally avoid them in favor of
customized tables in the worksheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "vcff" wrote in message ... Thanks for your reply. No, I am refering to the DATA TABLE below the chart. I am able to see the complete figure (19576.35) unless I expand the chart to the right. However, I wish to maintain only a small chart on the worksheet. Any help will appreciated. Tnks "Jon Peltier" wrote: Presumably these are the horizontal axis tick labels? Select the axis or its tick labels and press CTRL+1 (numeral one) to open the Format Axis dialog. Click on the Alignment button on the left side of the dialog, then choose one of the options in the Text Direction dropdown. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "vcff" wrote in message ... I have a chart with the chart data displayed. However, it did not show the full figure (19576.35 was shown as 195) due to the size of the chart. How can I format the digit figure to vertical in order to show all the digits. Thank with Regards |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format alignment for XLS 2007 in the chart data
ok anyway thanks for your reply
"Jon Peltier" wrote: These data tables are pretty inflexible. I generally avoid them in favor of customized tables in the worksheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "vcff" wrote in message ... Thanks for your reply. No, I am refering to the DATA TABLE below the chart. I am able to see the complete figure (19576.35) unless I expand the chart to the right. However, I wish to maintain only a small chart on the worksheet. Any help will appreciated. Tnks "Jon Peltier" wrote: Presumably these are the horizontal axis tick labels? Select the axis or its tick labels and press CTRL+1 (numeral one) to open the Format Axis dialog. Click on the Alignment button on the left side of the dialog, then choose one of the options in the Text Direction dropdown. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "vcff" wrote in message ... I have a chart with the chart data displayed. However, it did not show the full figure (19576.35 was shown as 195) due to the size of the chart. How can I format the digit figure to vertical in order to show all the digits. Thank with Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cursor alignment with data points on scatter plot chart is offset | Charts and Charting in Excel | |||
| Text alignment issues in Excel 2007 | Excel Discussion (Misc queries) | |||
| Dollar format alignment | Excel Discussion (Misc queries) | |||
| Format Chart Title Alignment Vertical doesn't work | Charts and Charting in Excel | |||
| FORMAT CELLS ALIGNMENT | Excel Discussion (Misc queries) | |||
Hybrid Mode
