jrb
01-06-2010, 05:52 PM
I can't seem to find a way to create a chart in 2007. I did see you can create a pivot chart from a table, but I would like to also make a pie chart.
Right now I build a query in Access and paste the results to Excel and make the charts. I would transfer everything to Excel but the database is almost 900,000 records and loads of columns and the transfer to Excel has been bombing out.
If creating the charts in Excel is easiest that would be fine with me but is their a way to automate the transfer of data from Access to Excel.
Any thoughts?
Right now I build a query in Access and paste the results to Excel and make the charts. I would transfer everything to Excel but the database is almost 900,000 records and loads of columns and the transfer to Excel has been bombing out.
If creating the charts in Excel is easiest that would be fine with me but is their a way to automate the transfer of data from Access to Excel.
Any thoughts?