Access Access 2010 Pie Charting

[ace1259]

Hello,

I have a query that returns values in about 20 columns. I have two values in columns that I would like to make a pie chart of in a report. I'm trying to find a way to get the data from those two columns into rows in order for the chart to work. Example..

I have:

AirXSegs AirYSegs
767 896

and need a table or query with:

Airline Segments
AirX 767
AirY 896

Any suggestions on how to accomplish via VBA or union query? I can't seem to find anything that has worked yet. Thanks!

 

[Anon_F]

Have you tried Google or going to a more specialized access forum for help?
As you may wait a while here & good luck!