I need to distinguish two diffrent areas in the plot area of an excel chart.
Is it possible to colour the plot area with two different colours for that
purpose ?
Thanks
I need to distinguish two diffrent areas in the plot area of an excel chart.
Is it possible to colour the plot area with two different colours for that
purpose ?
Thanks
Yes, you can. Just double click your plot area and then use the "fill
effect" dialog to do this. You can color your chart plot area with one/two
or even a picture. Have fun!
Thank you very much fro your response
I am afraid I did not made myself understodd. The problem I have is that I
measure the lenght od several piece parts and I want to plot those data in a
chart but colouring the tolerance field in the plot area in a different
colour to the area where data of piece parts out of tolerance are plotted.
It is related to a cerain range of values in the Y axis, for example.
For example plot area corresponding to Y values in the range 1 to 5 (that
represents the field within tolerance range) would be coloured in a different
colour that the rest of the plot area where data out of tolerance are plotted.
I think it is not possible to have different colours related a value ranges
in a plot area, isn't it.
If you know the response I would very much appreciate if you could let me
know.
Best regards
"AAA" wrote:
> Yes, you can. Just double click your plot area and then use the "fill
> effect" dialog to do this. You can color your chart plot area with one/two
> or even a picture. Have fun!
>
>
>
Hi,
You can use combination charts to colour the plot area.
Here some different examples.
http://peltiertech.com/Excel/Charts/...ackground.html
http://peltiertech.com/Excel/Charts/...ticalBand.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
Although this is not a solution to the sepcific problem the use of area
charts to shade might help.
http://www.andypope.info/ngs/ng21.htm
If none of the combinations work Jon has a VBA approach.
http://peltiertech.com/Excel/Charts/VBAdraw.html
Cheers
Andy
nasrev wrote:
> Thank you very much fro your response
>
> I am afraid I did not made myself understodd. The problem I have is that I
> measure the lenght od several piece parts and I want to plot those data in a
> chart but colouring the tolerance field in the plot area in a different
> colour to the area where data of piece parts out of tolerance are plotted.
>
> It is related to a cerain range of values in the Y axis, for example.
>
> For example plot area corresponding to Y values in the range 1 to 5 (that
> represents the field within tolerance range) would be coloured in a different
> colour that the rest of the plot area where data out of tolerance are plotted.
>
> I think it is not possible to have different colours related a value ranges
> in a plot area, isn't it.
>
> If you know the response I would very much appreciate if you could let me
> know.
>
> Best regards
>
> "AAA" wrote:
>
>
>>Yes, you can. Just double click your plot area and then use the "fill
>>effect" dialog to do this. You can color your chart plot area with one/two
>>or even a picture. Have fun!
>>
>>
>>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Thank you very much, Andy
"Andy Pope" wrote:
> Hi,
>
> You can use combination charts to colour the plot area.
> Here some different examples.
> http://peltiertech.com/Excel/Charts/...ackground.html
> http://peltiertech.com/Excel/Charts/...ticalBand.html
> http://tushar-mehta.com/excel/newsgr...ial/index.html
>
> Although this is not a solution to the sepcific problem the use of area
> charts to shade might help.
> http://www.andypope.info/ngs/ng21.htm
>
> If none of the combinations work Jon has a VBA approach.
> http://peltiertech.com/Excel/Charts/VBAdraw.html
>
> Cheers
> Andy
>
> nasrev wrote:
> > Thank you very much fro your response
> >
> > I am afraid I did not made myself understodd. The problem I have is that I
> > measure the lenght od several piece parts and I want to plot those data in a
> > chart but colouring the tolerance field in the plot area in a different
> > colour to the area where data of piece parts out of tolerance are plotted.
> >
> > It is related to a cerain range of values in the Y axis, for example.
> >
> > For example plot area corresponding to Y values in the range 1 to 5 (that
> > represents the field within tolerance range) would be coloured in a different
> > colour that the rest of the plot area where data out of tolerance are plotted.
> >
> > I think it is not possible to have different colours related a value ranges
> > in a plot area, isn't it.
> >
> > If you know the response I would very much appreciate if you could let me
> > know.
> >
> > Best regards
> >
> > "AAA" wrote:
> >
> >
> >>Yes, you can. Just double click your plot area and then use the "fill
> >>effect" dialog to do this. You can color your chart plot area with one/two
> >>or even a picture. Have fun!
> >>
> >>
> >>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks