Re: Some text boxes on an embedded chart do not show up

When you get your textbox issue sorted out, also consider that JPG is
usually a poor choice for an exported chart. PNG is probably best, and GIF
is also generally good. I've written about this recently:

http://peltiertech.com/WordPress/20...-as-image-file/
http://peltiertech.com/WordPress/20...hart-procedure/
http://peltiertech.com/WordPress/20...xported-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Laurence Lombard" <lombardm@mweb.co.za> wrote in message
news:PbidnbccMP5jDO3VnZ2dnUVZ8umdnZ2d@saix.net...
> Why is it that the last one or two text boxes on an embedded chart do not
> display when I click outside the chart area?
>
> I am using 16 text boxes on a chart instead of the legend as it makes it
> easier to read. I then select an area that includes the chart and copy it
> to Paint (see note 1), where I save it as a JPG as I want to load it onto
> the web. The Excel file and the JPG file can be found at the following
> links
>
> http://mysite.mweb.co.za/residents/...aph20080705.xls
> http://mysite.mweb.co.za/residents/...aph20080705.JPG
>
>
> Why is it that the last one or two text boxes do not show up when I click
> outside the Chart Area. In the files above the text box "Cyber
> Voortrekker" does not show up when I click outside the chart area (nor is
> it visible in the JPG image - it is the last pink coloured series at the
> bottom of the chart)? I am using Excel 2000. All the text boxes have been
> entered in the same way (ie I have ensured that the chart area has been
> selected so that the text box is on the embedded chart and not on the
> spreadsheet).
>
> I am really puzzled by this.
>
> NOTE 1: I find that the definition of the final JPG is better if I select
> a spreadsheet area enclosing the chart as opposed to clicking on the chart
> itself before the copy/paste to paint. Are the any better ways of creating
> a JPG image of an Excel chart?
>
> Many thanks
> Laurence
>