Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale of Data Table in Graph Object
I can change the scale of numbers on my axis, but can I do that to the
numbers in the data table, if I put one in the graph object? Ack! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale of Data Table in Graph Object
I'm not sure exactly what your asking for, but the built-in data tables don't
allow modifications. An alternative is to create your own data table in the worksheet. Then use the camera tool to copy it as a picture into your chart. Using the camera tool will allow you to still retain links to the cells. You can get to the camera tool via the View - Toolbars - Custom option. -- John Mansfield http://cellmatrix.net "ST" wrote: I can change the scale of numbers on my axis, but can I do that to the numbers in the data table, if I put one in the graph object? Ack! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale of Data Table in Graph Object
Perfect. I have a graph with a y axis in the Millions. I changed the scale
down to be 10, 20, 30 - instead of 10,000,000 etc. But I wanted to shorten/clean up the data table too. It is good to know I can't adjust it. I would have spent more time hitting my head against my ugly cube wall. THANK YOU! "John Mansfield" wrote: I'm not sure exactly what your asking for, but the built-in data tables don't allow modifications. An alternative is to create your own data table in the worksheet. Then use the camera tool to copy it as a picture into your chart. Using the camera tool will allow you to still retain links to the cells. You can get to the camera tool via the View - Toolbars - Custom option. -- John Mansfield http://cellmatrix.net "ST" wrote: I can change the scale of numbers on my axis, but can I do that to the numbers in the data table, if I put one in the graph object? Ack! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale of Data Table in Graph Object
Hi,
Creating your own data table is usually the simplest approach if you need to have complete control over the tables appearance. But you could change the cells number format to #,, and the values will change in the data table. Although you may need to set the axis number format to General if you are displaying in Millions. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "ST" wrote in message ... Perfect. I have a graph with a y axis in the Millions. I changed the scale down to be 10, 20, 30 - instead of 10,000,000 etc. But I wanted to shorten/clean up the data table too. It is good to know I can't adjust it. I would have spent more time hitting my head against my ugly cube wall. THANK YOU! "John Mansfield" wrote: I'm not sure exactly what your asking for, but the built-in data tables don't allow modifications. An alternative is to create your own data table in the worksheet. Then use the camera tool to copy it as a picture into your chart. Using the camera tool will allow you to still retain links to the cells. You can get to the camera tool via the View - Toolbars - Custom option. -- John Mansfield http://cellmatrix.net "ST" wrote: I can change the scale of numbers on my axis, but can I do that to the numbers in the data table, if I put one in the graph object? Ack! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scale on line graph | Charts and Charting in Excel | |||
changing the scale on the graph | Charts and Charting in Excel | |||
Data table in a graph | Excel Discussion (Misc queries) | |||
how can I change the scale of the numbers in my chart data table? | Charts and Charting in Excel | |||
Graph on Inverted Scale | Charts and Charting in Excel |