Chart size when html output

I am unable to resize a chart that is on its own tab.  When I activate it and try to resize it by grabbing the handles, the handles dispappear. What I am ultimately trying to do is properly size the chart for an html file. Perhaps there is a better way to do it? 
0
anonymous (74722)
2/26/2004 11:21:07 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
264 Views

Similar Articles

[PageSpeed] 13

Embed the chart on a worksheet. You have great control over the size of 
an embedded chart. You can line up the chart edges to the cell 
boundaries, too, if you hold down the Alt key while moving and resizing 
the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

RHolland wrote:

> I am unable to resize a chart that is on its own tab.  When I
> activate it and try to resize it by grabbing the handles, the handles
> dispappear. What I am ultimately trying to do is properly size the
> chart for an html file. Perhaps there is a better way to do it?

0
jonxlmvpNO (4558)
2/27/2004 6:09:15 PM
Thanks.
0
anonymous (74722)
3/3/2004 11:31:05 AM
Reply:

Similar Artilces:

Scaled Chart Axes
I have created a chart from data in Excel and I would like to be able to scale the axes (both x and y) to say 2cm per gradation - ending up with a square chart with each gridline 2cm apart. Is this possible to achieve in vb? All help appreciated - thanks Jon Peltier has instructions for squaring the gridlines: http://www.peltiertech.com/Excel/Charts/format.html#SqrGrid patrick wrote: > I have created a chart from data in Excel and I would like to be able to > scale the axes (both x and y) to say 2cm per gradation - ending up with a > square chart with each gridline 2cm apart...

VBA charts
Why does Excel 2007 not record ALL comands which I implement while using the macro recorder in making/changing charts? Hi, The macro recorder for the new items in xl2007, charts and shapes, is very incomplete :( Unless you have a previous version to record with you will need to work with the object browser and intellisense in order to manually create your code. Cheers Andy rolando wrote: > Why does Excel 2007 not record ALL comands which I implement while using the > macro recorder in making/changing charts? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info ...

Increase size of Legend Key in Pie Charts
Hi, Does anyone know how to increase the size of legend keys (the colour blocks) in charts (am presently working on pie charts...)??? I'd prefer not to increase the size of the font... Thanks in advance :-) Unfortunately, the size of the legend keys is tied to the font size. You can change the color, but there is not a way to change just the size of the legend key. "Mark" wrote: > > Hi, > > Does anyone know how to increase the size of legend keys (the colour blocks) > in charts (am presently working on pie charts...)??? > > I'd prefer not t...

OT
Slightly off topic - counldn't find any appropriate group on my server. I'm running a prog in debug mode (VC7.1.3088) for several hours or more and I'm sending a lot of output via ATLTRACE2 to the output window. In the past I've had a couple visual studio crashes and I wondered if there was any restriction on the amount of data the output window can safely take - or there are any bugs linked to this. TIA "Joe" <not@here.com> wrote in message news:4230fa32$0$10953$cc9e4d1f@news-text.dial.pipex.com... > Slightly off topic - counldn't find any appr...

Font size across platform
Hello, Why do documents when opened in Macintosh are rendered a lot smaller (visually) than when opened on a PC? For example - if an excel document is created using 12pt Times New Roman, it is perfectly legible when opened on a PC. When done under osx, it is tiny and so you have to zoom in to view it (to 125-130%). If you save any changes, then the zoom is saved. So what? I am an independent consultant and work in teams that primarily use PC and there is constant filesharing between team members. It is a real nuisance when transferring files, especially clients who sometimes reduce the font...

Function to determine Directory Size
I'd like to be able to determine the size of a directory or group of files. Does anyone know of an add-in that has a function whereby I can specify a path and get the size of directory of groups of files as the return value? Ex: =dirsize("C:\Documents and Settings\Bob\My Documents\School") =dirsize("C:\Documents and Settings\Bob\My Documents\School\*.doc") It would also be helpful if there were an option to include subdirectories. -- Thanks, Bob Chmara Argh.... Make that "get the size of a directory or group of files" Bob "Bob Chmara" fatfing...

Can I use an industry standard XSD and ADO.NET / SQLServer to output a conforming XML file
We have tentatively agreed with a supplier to exchange order information. The plan is to use an 'industry standard' order schema definition from say www.xcbl.org. Is there are simple way to use ADO.NET in this scenario. Ideally (naively) I would like to do something along these lines : 1. Create a SQLServer stored proc that returns a dataset (or similar) containing the order details such as : select PurchaseOrderID,ProductID,Qty from PurchaseOrder join PurchaseOrderItem...... 2. In a COM+ object (not entirely relevant to the problem, but this is how it will work), I would expe...

Junk Filter 1024 size limit?
I get an error on OWA 2003 when I try to add additional entires to my Block Senders List, that I am over the size limit allocated at the server level - Contact your Admin. My question is: How and where do I increase this limit? thanks! V2l0aCBhIHByb3BlciBBbnRpU1BBTSBTb2x1dGlvbi4gOy0pIA0KSnVzdCBnb29nbGUgZm9yIGl0 LiBNYXliZSB5b3UgZXZlbiBmaW5kIHNvbHV0aW9ucyB3aGljaCBzdXBwb3J0IG5ldyB0ZWNobm9s b2dpZXMgbGlrZSBTUEYgYW5kIENhbGxlcklELg0KQW5kcmVhcw0KDQoiQmVybmQiIDxiZGlibGlr QHNvbGJvdXJuZS5jb20+IHdyb3RlIGluIG1lc3NhZ2UgbmV3czoxOUYwRjI4Ni01ODk5LTRBQTYt QjFEOS02MjAxQjExNTJCMjJAbWljcm9zb2Z0LmNvbS4uLg0KPiBJI...

hOW WE CAN HAVE FLICKKER FREE MS CHART
HI ALL HOW ,WE CAN HAVE A FLICKER FREEE MSCHART. I MADE ONE MSCHART,BUT ON CLICKING ITS REFRESH BUTTONS ,FLICKKERING OCCURS,SO HOW I CAN PREVENT THAT. ARBIND ...

100% stacked column chart with negative numbers
How do you create a 100% stacked column chart with negative numbers? After I create the chart it only goes up to 80% How do you want it to show? The total length (including negative amount) of the column should equal 100%. (make sure you haven't limited the scale of your y-axis) What the graph is showing you is that the positive numbers do not account for 100% of your data. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Stuck" wrote: > How do you create a 100% stacked column chart with negative numbers? After I > create th...

Chart with Named Range error
Using Excel 2007, creating a chart using named ranges as inputs when I try ti enter the named range as a source I get a formula error "the formula you typed containes an error..." So I setup a simple scenario to dumlicate the problem. named a range of cells "Test" and entered arbitrary numbers in the cells of the range. Insert chart, Right click on the chart and select "select data" then "add" In the box type "=Test" or used the "Use in formula/paste name" tool. Select ok and get the formula error. I dont think I had any problems w...

dynamic chart partial row
I am trying to create a dynamic chart (latest 25 months) using data added monthly to columns. I have, however, uncharted data to the right of said data (blank column separating). I've tried many OFFSET formulas with no success. Sample data: Col A Col B Col C Col D Etc Entity Jan04 Feb04 Mar04 (Presently To Dec08) A 25 17 9 B 58 22 13 C 109 39 24 TIA, casey Try using a data range formula of =OFFSET(A1,0,MATCH(DATE(YEAR(TODAY()),MONTH(TODAY())-25,1),1:1,0),4,MA...

Cutting off the bottom of a chart?
I'm charting my weight loss, and I'd like to see more detail. My x-axis is weeks, my y-axis is my weight. I'm never going to get below 150 -- How do I get the chart to just show the y-axis between, say, 150 and 350? Thanks in advance, -- Lew Bryson Lew@LewBryson.com www.LewBryson.com In article <ZX3wg.128236$H71.12170@newssvr13.news.prodigy.com>, kingofwazoos@hotmail.net says... > I'm charting my weight loss, and I'd like to see more detail. My x-axis is > weeks, my y-axis is my weight. I'm never going to get below 150 -- How do I > get the c...

Maximizing Userforms to suit any screen size
Hi all, I was wondering if it is possible to get a userform to maximize itself automatically (to fill the entire screen) when it is activated. Currently I set my userforms properties width to be 417.75 and height to be 600 - which is fine for some screens but not for others. It would be better if I include some code that could determine the users screen resolution - and then maximize the userform automatically to fill the entire screen of any end-user, no matter what the size or the resolution setting. Thanks for any help with this Regards Karen Karen If you adjust the lngSize values the...

help on macro for making chart
Hi, i want to make a plot using macro where I want my x-axis to be the value from the same column but random rows for example R18C3,R19C3,R21C3,R23C3,R25C3,R27C3 ( only rows are changing) and my Y-axis should also be something like this R18C5,R19C5,R21C5,R23C5,R25C5,R27C5 ( only rows are changing) For one plot It is working but i do not know how i can plot for other columns... the code looks like this Sub Macro2() ' ' Macro2 Macro ' Macro recorded 3/30/2007 by Roger ' ' Keyboard Shortcut: Ctrl+m ' Charts.Add ActiveChart.ChartType = xlXYScatterLines ...

Excel log/log chart
Using the previous version of Microsoft Excel (Excel '95), I was easily able to produce a log/lock chart, using the scatter chart as a starting point, without any problem whatsoever. This included placing two and more series on the same chart. With the new version that is installed on my machine (which is Excel 97), I can no longer complete this rather simple task. Does anyone know how to produce a log/log chart of two and more sets of values (using X-Y values)? My Desire Is to Have One Set of X-Y values with another set (A-B) of values as well as a third set of values (M-N) p...

Chart Axes Linked to cell values
Hello Everyone. I have some sort of a problem with linking chart axe (min and max values) to cell values in a worksheet. I am using th macro that I found in Mr Peltier' site: http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html It worked just fine for a simple test I was doing.. BUT, I came up wit the idea of assigning to the cells (the cells that contain the scal params) some worksheet functions, to determine the values from a set o data. When I did this, the macro didn't work anymore. It didn't pop u any errors or such things, it just didn't adjust the chart anymo...

My chart won't show on new sheet
I am having a problem with an assignment for my class and am NOT getting help from anyone. I am using Office 2007, have Vista HP, and am working on the Excel 2007 course. The problem is that when I try to move the chart to a new sheet using the move chart button, the new sheet is created but the chart can not be seen. I am about ready to use my text book as kindling. Can anyone at all lead me to see what I am doing wrong? Hi Julie. On the desing tab under chart tools you click on move chart and select as object in new sheet? "Julie W." wrote: > I am having a problem with ...

Stacked Column Chart #4
Date Event type Total 01-01-2006 A 10 01-01-2006 B 15 01-01-2006 C 12 02-01-2006 A 5 02-01-2006 B 7 02-02-2006 C 8 03-02-2006 A 5 03-02-2006 B 15 I would to generate a automatic stacked column (without having to mak manual selections) with the example above.The final result should b the date in the x axis and the column composed by the event typ (A,B,C) with the respective total. Note: the information is displayed as shown above. How can i do this? Thanks, Regards Andr -- vilacov ----------------------------------------------------------------------- vilacova's Profile: http://www.ex...

How to copy a chart between workbooks?
Another guy in my office has a nice chart which I want to use in my own weekly report. He has it posted on a shared network drive. How do I copy his chart into my workbook? I'm using Excel 2003. Thanks in advance, David Portwood Open the workbook he posted then select the Chart or Chart Sheet and Chart>Chart Type>Custom Types>User Defined>Add this to the List of User Defined Charts. This will add the Chart Type to your xl8galry.xls workbook which you didn't even know you had<g> You then use that chart type as your base for your reports. Gord Dibben MS Exce...

I need help with charts in Excel 2007
I need help with inserting dates on the axes. I have dates as my column headings on my worksheet in row 2. I am trying to create a chart using the dates and just the data I have entered in a particular row, say row 12. It works fine if I chose line 3, but I need to create charts using other lines. Is this possible? Select the data in row 2, then hold CTRL while selecting the data in another row, and insert your chart. Alternatively, create your chart, and on the Chart Tools > Design tab, choose Change Data, and change the reference from row 3 to row whatever. Or select the series,...

Form print problem
Hi I'm not if this is the right place to post this issue, but here we go: I have a database application, which when prompted prints out a detail section of a form. This has been working nicely in access 2000, in which the application has been developed. Now I have installed access 2003, and suddenly an empty blank page is printed before the actual page. In the design view under page setup I can see that the paper size is "Letter" - In access 2000, however, the paper size was set to "A4". I can't change the setting - it always reverts to "Letter". I ...

Excel 2003 printing oddity - missing border
This is an odd one - I've got a spreadsheet that I've been printing quite happily on legal-sized paper. When I print the same document, however, on 11 x 17 paper, exactly one of the borders is not printing - it's the border between Column C and Column D. There are absolutely no other issues - everything else looks exactly the same as on legal paper, just bigger. Any clues? Many thanks - ...

Chart non consecutive data
Is it possible to chart non-consecutive data. I haven't been successful in my attempts so far. Data is in same row, ie. row 4; columns needed are H4 and J4 (need to be stacked), next series is K4 , L4 & M4. Unfortunately, I can not rearrange the cells to make this easier. Any help or suggestion would be appreciated. I haven't done that much charting with Excel (2003). TIA XL doesn't stack data in the same series. It stacks one series on top of the previous. You can simulate the effect you want as follows. Select H4:J4 and create a stacked column chart. In step ...

Setting Split form Window Sizes
I can't get A2007 to remember any Split form window sizes after trying various options for the last 4 hours I've had enough, this should be simple. I've got Access options set to overlapping windows. I've switched off Auto Resize and Fit to Screen. I've tried saving the form after I've sized it to how I want. None of the above works - I can nearly get it to work if I set the "Split Form Orientation" to Datasheet on right, but it's still not how I save it!!! If I set the "Orientation" to below it's nowhere near and sometimes...