CODEWITHSUNDEEP
excelsortingms-accesschartspivot
jpWebLearner
jpWebLearner

Reputation: 67

MS-Access Pivot Chart

Could someone help me to sort and arrange the Pivot Chart in MS-Access please. I could do this easily in MS-Excel, but not in MS- Access. I need a gap in between each Task + Budget in MS- Access chart exactly as in MS- Excel. If you put a blank record in Access table, then sorting becomes an issue. Actually the sorting of X axis is not flexible enough in MS-Access and it simply sorts alphabetically. Thanks enter image description here

Upvotes: 4

Views: 752

Answers (2)

donPablo
donPablo

Reputation: 1959

This is one way to implement Sten's solution.
Create another column in the query, and union it with the existing data

Select
    Replace(Task," Budget","") as TaskGrp,
    Task,
    Employee,
    Amount
From Table1

Union

Select 
    Replace(Task," Budget","End") as TaskGrp,
    Null,
    Null,
    Null
From Table1
Where instr(Task,"Budget") > 0

Order By TaskGrp, Task, Employee

Then omit TaskGrp when doing the chart

Upvotes: 1

sten
sten

Reputation: 380

Yeah, what I mean is add the value of a space. " ". Technically the space will show in the graph but no one will be able to see it. You can have an extra column which doesn't go into the graph for sorting.

Upvotes: 0

Related Questions