Add something to graphs in a form.

[TrulyVisceral]

I suck at titles, but what I mean is this:




Both graphs are effectively the same, but the one on the left was added those blue, green and yellow sections. Now, those are independent from the graph, they don't form part of it. That's not the problem.
The problem is that I need those on the right, but to be PART of the graph, so it can be easily copy-pasted into something else.

If they cannot form part of the graph, then what, just go to form designer and add a bunch of rectangles on top?

[isladogs]

AFAIK you can't do this in Access charts.
You will need to do a workround if its that important to you

[TrulyVisceral]

Well crap. Guess it's gotta have to be done manually everytime it's copy pasted.

The thing is, the graph has to be taken to a PowerPoint presentation. Kind of annoying to have to put the rectangles everytime.

[TrulyVisceral]

AFAIK you can't do this in Access charts.
You will need to do a workround if its that important to you

Well, I got something else.
To take the incidents from each of the 3 sections and give a total.
What I mean is, how many incidents from 6 to 8? How many from 8 to 17? and how many from 17 to 21?
Of course, that would be done in a Query. Should I make a new thread?

[isladogs]

You can certainly add one colour to the entire grid but that's all
Improved charting is apparently on its way in the next few months as part of the Office 2019 update

EDIT: New thread might be better for your second question

[TrulyVisceral]

You can certainly add one colour to the entire grid but that's all
Improved charting is apparently on its way in the next few months as part of the Office 2019 update

EDIT: New thread might be better for your second question

So this is unsolvable until the next version, got it.
Marking this as solved and creating a new thread then.

[isladogs]

I didn't say that would be fixed in the next version as I haven't seen the improved charting features.
Perhaps someone who was at the Devcon conference in April will know if that's part of the planned changes

[TrulyVisceral]

Neither of us knows, but w/e, I made the other thread