M
metalone
Is there a way to change how data in a chart is sorted?
The chart is on a form and displays two types of information - Y axis
is the total cost and X axis is the part number. The chart is sorting
on the X axis alphabetically and I need it to sort by the highest price
for each of the parts. The data is pulled from a query that is set up
to filter by the top 25 items by highest cost (items are summed and
only the First of each part is shown) and is sorted in the query by
desending cost.
Thanks
Sean
The chart is on a form and displays two types of information - Y axis
is the total cost and X axis is the part number. The chart is sorting
on the X axis alphabetically and I need it to sort by the highest price
for each of the parts. The data is pulled from a query that is set up
to filter by the top 25 items by highest cost (items are summed and
only the First of each part is shown) and is sorted in the query by
desending cost.
Thanks
Sean