Sort Data used in Chart Wizard

[JayRab]

Ok have a form with several charts on it all made from different queries. It appears that when using the chart wizard it creates a crosstab query, I want to sort this query by the SumofDowntime Hours below is the row source code

TRANSFORM Sum([SumOfSumOfDown]) AS [SumOfSumOfSumOfDown] SELECT [Equipment] FROM [Truck30DayBreakdown]   GROUP BY [Equipment] PIVOT [Equipment];

Here is a pictire of the graph

as you can see I would like it in order so the largest number on the right with decreases downtime hours as you go left.

I tried to add an ORDER BY clause in but it didnt work, probably didnt have it in correct syntax or something.

Any help would be appreciated.



Thanks

[June7]

The purpose of bars on a bar chart is to readily identify the highs and lows regardless of order. Bars are ordered by the x axis categories (the CROSSTAB headers), not the aggregate values.

None of my charts use CROSSTAB but none of my charts are bar charts.

[JayRab]

I agree 100% but the boss likes it in descending order lol

[June7]

Well, I have never seen a bar chart generated by any product do that. Is Boss OCD?

[JayRab]

Excel you can do it easily, just sort data prior to selecting data. Pivot Tables do the Same. Paretos...

Yes Boss is OCD.

Paretos gave me an idea and it worked...Just need to create 4 different PivotChart Forms and add as sub forms in the main form. Thanks lol

[June7]

Maybe I have seen that and just didn't register in memory. Still a lot to learn about graphing. I've never used pivot table/chart nor bar graph, just line and scattered.

Very creative. However, I don't understand how 4 PivotChart forms result in a single graph.

OCD boss doesn't find the non-alpha sort legend annoying?

[JayRab]

Not a single graph but 4 seperate graphs. Before I had 4 charts using that Chart wizard. Now I just made 4 pivot Charts forms. In a tabbed form.

[June7]

Thank you for the clarification.

Be aware that MS removed pivot table/chart functionality from Access 2013.

[JayRab]

That sucks...I guess no one used it is that why they removed it??

[June7]

I have read enough posts from disappointed users indicating it was definitely used. Who knows MS rationale? Maybe that Excel charting has more capability, until you hit 1,048,576 rows.

[JayRab]

Is there an easy way to bring in charts from excel into Access reports, forms, etc? Are they able to be dynamic so as my data changes inside the database it automatically updates.

Or will this require a lot of VBA? To export, manipulate data, generate graph, then reinsert back to access?

Thats why I like Access stuff. Managers can just open database and it automatically updates throughout the day as data is input. I do not have to touch it for it to be updated.

[June7]

Never done that.

Bing: Access embed Excel chart in form

Does this help http://www.brighthub.com/computing/w...les/26778.aspx

[JayRab]

Yes thank you.