Chart in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OM - 30 Aug 2006 12:57 GMT

Is it possible to convert a Chart in Excel so that it is "fixed", ie. still
looks the same, but is no longer connected to the source data ? I know that
I could save it as a jpg, and then insert it as a picture, but is there a
way to do it more directly.

Thanks,

Rob

Reply to this Message

R..VENKATARAMAN - 30 Aug 2006 13:30 GMT

I have a note in my notes
after drawings chart in conventional way
1.click the chart
2.highlight the formula in the fomrula bar
3.hit F9
4.hit enter
now the chart is based on actual data and not cells.

try a few small experiments.

> Is it possible to convert a Chart in Excel so that it is "fixed", ie.
> still looks the same, but is no longer connected to the source data ? I
[quoted text clipped - 4 lines]
>
> Rob

Reply to this Message

OM - 30 Aug 2006 22:49 GMT

Thanks for that - there is no formula in the formula bar unless I highlight
the data points. When I then select the formula that appears when the data
points are selected, and hit F9, it does convert the formula to individual
numbers, BUT.... the chart has 784 data points, and I get an error message
telling me my formula is too long....

Thanks anyway - a useful tip for smaller graphs for sure.

Rob

>I have a note in my notes
> after drawings chart in conventional way
[quoted text clipped - 14 lines]
>>
>> Rob

Reply to this Message

OM - 08 Sep 2006 10:54 GMT

Thanks for that - seems to work well.

Rob

>I have a note in my notes
> after drawings chart in conventional way
[quoted text clipped - 14 lines]
>>
>> Rob

Reply to this Message