Need to export a pivot chart view of a query

Hi -

I need to export the pivot chart view of a query to a word or excel document
so that it can be emailed or saved.

Any ideas?

AmandaM wrote:

Hi -

I need to export the pivot chart view of a query to a word or excel document
so that it can be emailed or saved.

Any ideas?

Several:

- Highlight all the fields/columns in your xtab query in Datasheet View
and Copy/Paste to Word or Excel

- OR select your xtab query in the Database Window, select File Save
As/Export, click the "To an external file or database" radio button,
then choose the preferred file type & destination.

- OR select your xtab query in the Database Window and use the
OfficeLinks toolbar button to "Analyze it with MS Excel" or "Publish it
with MS Word".

- OR to email the output of the query directly, select your xtab query
in the Database Window, then select File Send and follow the prompts.

That should get you started!

hth,

LeAnne

Thanks LeAnne - Unfortunately none of those options work, I still get the
datasheet pulling over rather than the chart.

"LeAnne" wrote:

AmandaM wrote:

Hi -

I need to export the pivot chart view of a query to a word or excel document
so that it can be emailed or saved.

Any ideas?

Several:

- Highlight all the fields/columns in your xtab query in Datasheet View
and Copy/Paste to Word or Excel

- OR select your xtab query in the Database Window, select File Save
As/Export, click the "To an external file or database" radio button,
then choose the preferred file type & destination.

- OR select your xtab query in the Database Window and use the
OfficeLinks toolbar button to "Analyze it with MS Excel" or "Publish it
with MS Word".

- OR to email the output of the query directly, select your xtab query
in the Database Window, then select File Send and follow the prompts.

That should get you started!

hth,

LeAnne

Could you clarify what you have and what you are trying to do? Did you
create a crosstab query (sometimes called a pivot table) that you wish
to export to Excel? Or did you use ChartWizard to add a chart to an
Access form or report?

LeAnne

AmandaM wrote:

Thanks LeAnne - Unfortunately none of those options work, I still get the
datasheet pulling over rather than the chart.

"LeAnne" wrote:


AmandaM wrote:


Hi -

I need to export the pivot chart view of a query to a word or excel document
so that it can be emailed or saved.

Any ideas?

Several:

- Highlight all the fields/columns in your xtab query in Datasheet View
and Copy/Paste to Word or Excel

- OR select your xtab query in the Database Window, select File Save
As/Export, click the "To an external file or database" radio button,
then choose the preferred file type & destination.

- OR select your xtab query in the Database Window and use the
OfficeLinks toolbar button to "Analyze it with MS Excel" or "Publish it
with MS Word".

- OR to email the output of the query directly, select your xtab query
in the Database Window, then select File Send and follow the prompts.

That should get you started!

hth,

LeAnne

LeAnne wrote:

Could you clarify what you have and what you are trying to do? Did you
create a crosstab query (sometimes called a pivot table) that you wish
to export to Excel? Or did you use ChartWizard to add a chart to an
Access form or report?


PS. Forgot to include this part. You didn't say which version of
Access/Office you are working with. But if you are working with a Chart
object created in a From or Report in A97:

- Open the Form or Report containing the graph in Design View
- Right click on the Chart object and Select Chart Object Edit
- Microsoft Graph should open 2 windows: a datasheet view of the
RecordSource data, and the chart itself
- From the menu bar select Edit Copy Chart
- You can now paste the chart into Excel or Word as an EMBEDDED object.
See Excel Help for information about working with embedded charts. Or
you can Paste Special the graph as a .jpg or other picture format if you
prefer.

hth,

LeAnne

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.

"LeAnne" wrote:

LeAnne wrote:

Could you clarify what you have and what you are trying to do? Did you
create a crosstab query (sometimes called a pivot table) that you wish
to export to Excel? Or did you use ChartWizard to add a chart to an
Access form or report?


PS. Forgot to include this part. You didn't say which version of
Access/Office you are working with. But if you are working with a Chart
object created in a From or Report in A97:

- Open the Form or Report containing the graph in Design View
- Right click on the Chart object and Select Chart Object Edit
- Microsoft Graph should open 2 windows: a datasheet view of the
RecordSource data, and the chart itself
- From the menu bar select Edit Copy Chart
- You can now paste the chart into Excel or Word as an EMBEDDED object.
See Excel Help for information about working with embedded charts. Or
you can Paste Special the graph as a .jpg or other picture format if you
prefer.

hth,

LeAnne

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


wince I'm afraid I'm not at ALL familiar with that functionality.
Anybody else knowledgeable in A03 want to take a crack at this?

Sorry,

LeAnne

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


PS. Amanda, here's a link to an article I found at office.microsoft.com:

http://office.microsoft.com/en-us/as...345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne

Thank you!!! I'm sure that will help...now I just have to get the code in
there. At least now I know it's possibble.

"LeAnne" wrote:

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


PS. Amanda, here's a link to an article I found at office.microsoft.com:

http://office.microsoft.com/en-us/as...345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne

Did you find out how to use the code for exporting the chart?
I have the same challange exporting graphs.


Jan

"AmandaM" wrote:

Thank you!!! I'm sure that will help...now I just have to get the code in
there. At least now I know it's possibble.

"LeAnne" wrote:

AmandaM wrote:

Hi LeAnne-

I'm working in Access 2003. I created a "select" query. When I had it
showing the data I wanted to chart, I went to ViewPivot Chart View. In that
window I created the Pivot Chart and saved it so that each time I run this
query I can click over to pivot chart view to see the charted data. (which
ultimately I would like to export)I hope this makes more sense.

Thanks for your help.


PS. Amanda, here's a link to an article I found at office.microsoft.com:

http://office.microsoft.com/en-us/as...345791033.aspx

Scroll down to "Samples for PivotChart view" and click on "Export the
PivotChart View as an image." There's a snippet of VBA code that will
enable you to export the chart object as a .gif.

LeAnne