Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
several different sized charts within the same sheet
I have to make a spec sheet with many different sized charts within the one
document. I will not be using any formulas. The question I have is how do I change the size of one chart (i.e. column width) without effecting the other charts on the same page? I'm using Microsoft Office 2003 version 11.0.8142 Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
several different sized charts within the same sheet
right click the chart Format Chart Area/properties/ UNCHECK move and size
with cells, then just move and size using the black boxes at the corners and sides of the chart, what do you call them, grab handles, and you can size each chart independently. "graimej" wrote: I have to make a spec sheet with many different sized charts within the one document. I will not be using any formulas. The question I have is how do I change the size of one chart (i.e. column width) without effecting the other charts on the same page? I'm using Microsoft Office 2003 version 11.0.8142 Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
several different sized charts within the same sheet
you can also change the size of the chart by simply grabbing one of the
corners of the chart and drag it.... "graimej" wrote: I have to make a spec sheet with many different sized charts within the one document. I will not be using any formulas. The question I have is how do I change the size of one chart (i.e. column width) without effecting the other charts on the same page? I'm using Microsoft Office 2003 version 11.0.8142 Thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
several different sized charts within the same sheet
Thanks for your quick response. But I'm not really using a "chart" per se...
I'm creating a form to be filled out & there are different boxes (i.e. charts) within it. Isn't there a way to make one chart which has 15 columns on the same sheet with another chart that has 9 columns - but for both charts to have different column widths yet take up the same amount of space on the sheet? Thanks again! "dlw" wrote: right click the chart Format Chart Area/properties/ UNCHECK move and size with cells, then just move and size using the black boxes at the corners and sides of the chart, what do you call them, grab handles, and you can size each chart independently. "graimej" wrote: I have to make a spec sheet with many different sized charts within the one document. I will not be using any formulas. The question I have is how do I change the size of one chart (i.e. column width) without effecting the other charts on the same page? I'm using Microsoft Office 2003 version 11.0.8142 Thank you! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
several different sized charts within the same sheet
no - each column has one specific width. However, look at the functionality
in the drawing toolbar, add textboxes etc. In that way you are not dependant on column width. Or - use a different program..... "graimej" wrote: Thanks for your quick response. But I'm not really using a "chart" per se... I'm creating a form to be filled out & there are different boxes (i.e. charts) within it. Isn't there a way to make one chart which has 15 columns on the same sheet with another chart that has 9 columns - but for both charts to have different column widths yet take up the same amount of space on the sheet? Thanks again! "dlw" wrote: right click the chart Format Chart Area/properties/ UNCHECK move and size with cells, then just move and size using the black boxes at the corners and sides of the chart, what do you call them, grab handles, and you can size each chart independently. "graimej" wrote: I have to make a spec sheet with many different sized charts within the one document. I will not be using any formulas. The question I have is how do I change the size of one chart (i.e. column width) without effecting the other charts on the same page? I'm using Microsoft Office 2003 version 11.0.8142 Thank you! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
several different sized charts within the same sheet
ok :(
Thanks :) "rdwj" wrote: no - each column has one specific width. However, look at the functionality in the drawing toolbar, add textboxes etc. In that way you are not dependant on column width. Or - use a different program..... "graimej" wrote: Thanks for your quick response. But I'm not really using a "chart" per se... I'm creating a form to be filled out & there are different boxes (i.e. charts) within it. Isn't there a way to make one chart which has 15 columns on the same sheet with another chart that has 9 columns - but for both charts to have different column widths yet take up the same amount of space on the sheet? Thanks again! "dlw" wrote: right click the chart Format Chart Area/properties/ UNCHECK move and size with cells, then just move and size using the black boxes at the corners and sides of the chart, what do you call them, grab handles, and you can size each chart independently. "graimej" wrote: I have to make a spec sheet with many different sized charts within the one document. I will not be using any formulas. The question I have is how do I change the size of one chart (i.e. column width) without effecting the other charts on the same page? I'm using Microsoft Office 2003 version 11.0.8142 Thank you! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
several different sized charts within the same sheet
You can experiment with merging of cells. In many cases, merged cells will
be a major inconvenience, but for a simple data entry form, it probably will not affect you adversely. Do the input tables have to be on the same worksheet? If not, use separate sheets, and modify each sheet as appropriate. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "rdwj" wrote in message ... no - each column has one specific width. However, look at the functionality in the drawing toolbar, add textboxes etc. In that way you are not dependant on column width. Or - use a different program..... "graimej" wrote: Thanks for your quick response. But I'm not really using a "chart" per se... I'm creating a form to be filled out & there are different boxes (i.e. charts) within it. Isn't there a way to make one chart which has 15 columns on the same sheet with another chart that has 9 columns - but for both charts to have different column widths yet take up the same amount of space on the sheet? Thanks again! "dlw" wrote: right click the chart Format Chart Area/properties/ UNCHECK move and size with cells, then just move and size using the black boxes at the corners and sides of the chart, what do you call them, grab handles, and you can size each chart independently. "graimej" wrote: I have to make a spec sheet with many different sized charts within the one document. I will not be using any formulas. The question I have is how do I change the size of one chart (i.e. column width) without effecting the other charts on the same page? I'm using Microsoft Office 2003 version 11.0.8142 Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error rsp about merged cells being sized ? | New Users to Excel | |||
How do I keep charts from opening in sized with window view? | Charts and Charting in Excel | |||
How do I print different sized tables on one sheet? | Excel Discussion (Misc queries) | |||
Summing a variably-sized range | Excel Worksheet Functions | |||
How do I add a larger sized, blank every other row in a spread she | Excel Discussion (Misc queries) |