graphs

[Mauro]

Hello everybody, I have a question concerning graphs.
I need a graph to be behind a picture. All I need to see are the dots. In
Word it is possible to insert a picture and then set it "behind text". Is it
possible to do something like that in Excel?
Thanks

[JulieD]

Hi Mauro

why don't you set the background of your graph to the picture (double click
on the grey bit at the back of the chart - choose fill effects, choose
picture tab, choose select picture and put your picture in there), change
the chart to a line chart (chart / chart type) and then format the chart
series to dots only - double click on the charted series and turn off the
lines

Hope this helps
Cheers
JulieD


"Mauro" <[email protected]> wrote in message
news:[email protected]...
> Hello everybody, I have a question concerning graphs.
> I need a graph to be behind a picture. All I need to see are the dots. In
> Word it is possible to insert a picture and then set it "behind text". Is
> it possible to do something like that in Excel?
> Thanks
>
>

[Mauro]

Hello Julie... sorry for the late reply...
your option can probably work but there is a problem. the picture I need to
use is already in the sheet and I don't know how to extract it and make it
jpg.... is there a way I can use it as it is?
thanks again
"JulieD" <[email protected]> wrote in message
news:[email protected]...
> Hi Mauro
>
> why don't you set the background of your graph to the picture (double
> click on the grey bit at the back of the chart - choose fill effects,
> choose picture tab, choose select picture and put your picture in there),
> change the chart to a line chart (chart / chart type) and then format the
> chart series to dots only - double click on the charted series and turn
> off the lines
>
> Hope this helps
> Cheers
> JulieD
>
>
> "Mauro" <[email protected]> wrote in message
> news:[email protected]...
>> Hello everybody, I have a question concerning graphs.
>> I need a graph to be behind a picture. All I need to see are the dots. In
>> Word it is possible to insert a picture and then set it "behind text". Is
>> it possible to do something like that in Excel?
>> Thanks
>>
>>
>
>

[JulieD]

Hi Mauro

not sure, i would click on the picture, do control & c to copy it, and then
paste it into a drawing program and save as a *jpg ... other than that i
really don't know.

Cheers
JulieD

"Mauro" <[email protected]> wrote in message
news:[email protected]...
> Hello Julie... sorry for the late reply...
> your option can probably work but there is a problem. the picture I need
> to use is already in the sheet and I don't know how to extract it and make
> it jpg.... is there a way I can use it as it is?
> thanks again
> "JulieD" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Mauro
>>
>> why don't you set the background of your graph to the picture (double
>> click on the grey bit at the back of the chart - choose fill effects,
>> choose picture tab, choose select picture and put your picture in there),
>> change the chart to a line chart (chart / chart type) and then format the
>> chart series to dots only - double click on the charted series and turn
>> off the lines
>>
>> Hope this helps
>> Cheers
>> JulieD
>>
>>
>> "Mauro" <[email protected]> wrote in message
>> news:[email protected]...
>>> Hello everybody, I have a question concerning graphs.
>>> I need a graph to be behind a picture. All I need to see are the dots.
>>> In Word it is possible to insert a picture and then set it "behind
>>> text". Is it possible to do something like that in Excel?
>>> Thanks
>>>
>>>
>>
>>
>
>

[Debra Dalgleish]

Andy Pope has a free add-in that you can use to export images:

http://www.andypope.info/vba/gex.htm


Mauro wrote:
> Hello Julie... sorry for the late reply...
> your option can probably work but there is a problem. the picture I need to
> use is already in the sheet and I don't know how to extract it and make it
> jpg.... is there a way I can use it as it is?
> thanks again
> "JulieD" <[email protected]> wrote in message
> news:[email protected]...
>
>>Hi Mauro
>>
>>why don't you set the background of your graph to the picture (double
>>click on the grey bit at the back of the chart - choose fill effects,
>>choose picture tab, choose select picture and put your picture in there),
>>change the chart to a line chart (chart / chart type) and then format the
>>chart series to dots only - double click on the charted series and turn
>>off the lines
>>
>>Hope this helps
>>Cheers
>>JulieD
>>
>>
>>"Mauro" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>Hello everybody, I have a question concerning graphs.
>>>I need a graph to be behind a picture. All I need to see are the dots. In
>>>Word it is possible to insert a picture and then set it "behind text". Is
>>>it possible to do something like that in Excel?
>>>Thanks
>>>
>>>
>>
>>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Mauro]

Thank you very much for your information. The add-in works.

"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> Andy Pope has a free add-in that you can use to export images:
>
> http://www.andypope.info/vba/gex.htm
>
>
> Mauro wrote:
>> Hello Julie... sorry for the late reply...
>> your option can probably work but there is a problem. the picture I need
>> to use is already in the sheet and I don't know how to extract it and
>> make it jpg.... is there a way I can use it as it is?
>> thanks again
>> "JulieD" <[email protected]> wrote in message
>> news:[email protected]...
>>
>>>Hi Mauro
>>>
>>>why don't you set the background of your graph to the picture (double
>>>click on the grey bit at the back of the chart - choose fill effects,
>>>choose picture tab, choose select picture and put your picture in there),
>>>change the chart to a line chart (chart / chart type) and then format the
>>>chart series to dots only - double click on the charted series and turn
>>>off the lines
>>>
>>>Hope this helps
>>>Cheers
>>>JulieD
>>>
>>>
>>>"Mauro" <[email protected]> wrote in message
>>>news:[email protected]...
>>>
>>>>Hello everybody, I have a question concerning graphs.
>>>>I need a graph to be behind a picture. All I need to see are the dots.
>>>>In Word it is possible to insert a picture and then set it "behind
>>>>text". Is it possible to do something like that in Excel?
>>>>Thanks
>>>>
>>>>
>>>
>>>
>>
>>
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

[Debra Dalgleish]

You're welcome, and thanks for letting me know that it worked.

If you have other questions about graphs, you could post them in the

microsoft.public.excel.charting

newsgroup, where people with an interest in that topic post and answer
questions.


Mauro wrote:
> Thank you very much for your information. The add-in works.
>
> "Debra Dalgleish" <[email protected]> wrote in message
> news:[email protected]...
>
>>Andy Pope has a free add-in that you can use to export images:
>>
>> http://www.andypope.info/vba/gex.htm
>>
>>
>>Mauro wrote:
>>
>>>Hello Julie... sorry for the late reply...
>>>your option can probably work but there is a problem. the picture I need
>>>to use is already in the sheet and I don't know how to extract it and
>>>make it jpg.... is there a way I can use it as it is?
>>>thanks again
>>>"JulieD" <[email protected]> wrote in message
>>>news:[email protected]...
>>>
>>>
>>>>Hi Mauro
>>>>
>>>>why don't you set the background of your graph to the picture (double
>>>>click on the grey bit at the back of the chart - choose fill effects,
>>>>choose picture tab, choose select picture and put your picture in there),
>>>>change the chart to a line chart (chart / chart type) and then format the
>>>>chart series to dots only - double click on the charted series and turn
>>>>off the lines
>>>>
>>>>Hope this helps
>>>>Cheers
>>>>JulieD
>>>>
>>>>
>>>>"Mauro" <[email protected]> wrote in message
>>>>news:[email protected]...
>>>>
>>>>
>>>>>Hello everybody, I have a question concerning graphs.
>>>>>I need a graph to be behind a picture. All I need to see are the dots.
>>>>>In Word it is possible to insert a picture and then set it "behind
>>>>>text". Is it possible to do something like that in Excel?
>>>>>Thanks
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html