Can't Save Changes to Charts

[ItsRoland]

I have a pie chart set up, which is displaying information properly, however there is always a section called "Slice 1" and I cannot get rid of it.

If I go into design view, right click the chart, chart object, edit, make changes, and save my changes, the changes I made won't be saved. No matter what I do "Slice 1" is always there with no data in it.



Can someone please tell me how to permanently remove this?

Thanks in advance!

[June7]

Are you saying when form or report opens, the data does not properly display? Or is it that just design view does not show the changes although form or report view does show data?

Try switching to form/report or layout view then saving.

[ItsRoland]

After making changes the changes are not reflected anywhere, even after saving. I've tried saving the report, closing it, and reopening it, as well as report view/ layout view/ design view/ print preview. The changes flat out just don't save. All the pie charts I've tried making have "Slice 1" on them no matter what I do.

Going back into the editor also shows my changes not being there, "Slice 1" isn't removed.

[isladogs]

Can you post the sql for your chart and also the datasheet.
Is it a standard pie chart or a 'special' type?

Also, as a test, try changing the chart type to a bar chart. Save. Do you get your phantom item?
Now change it back. Save again. Does that help?

[ItsRoland]

SELECT [riskRating],Count([Expr2]) AS [CountOfExpr2] FROM [qPieChartTest] GROUP BY [riskRating];

The only relevant column in the table is [riskRating], theres a lot of other data in the table but none of it actually matters here, but if its absolutely crucial I post a copy of the table I will.

The pie chart is just a standard pie chart, at least I'm assuming that's what it is, considering I just selected pie chart in the chart wizard.

[June7]

I cannot replicate issue with my data. But I am not referencing a calculated field. Try Count(*). Will Expr2 ever have Null result?

[ItsRoland]

After making that change the issue still persists.

Sorry if I'm dumb, but I'm not sure I understand how any of this affects me not being able to save changes made in the chart editor. "Slice 1" doesn't appear anywhere in the source or the sql, and shows up regardless of how I set up any pie chart. I can set the source to anything and it still has "Slice 1", and I can't make changes. Note this is with and without a calculated field, using a table or a query as the source, so on and so forth.

Expr2 will not have a null result

[June7]

Was grasping at straws - brainstorming - because cannot replicate issue. You will have to provide data, maybe even the db.

[ItsRoland]

Cyber Risk Database - Working - Copy.zip


The report with the pie chart and the source query are in unassigned objects.

The table the query is using is "tScenarios", column is "riskRating"

[isladogs]

I've added a filter to risk rating to exclude empty records
It now works

[ItsRoland]

Sorry for the late response

I can see that what you did works, but I can't figure out where you added a filter. Is it in the query or the chart?

Sorry if it's obvious, haven't had my coffee yet this morning lol


Also, thanks a million for your help!

[isladogs]

Your chart object row source included a record where the risk rating field was empty.
Access added 'Slice 1' as a chart label
I just set filter criteria <>"" for that field to exclude it.

If preferred, you could also look at the underlying query to exclude those records at 'source'

[ItsRoland]

Thanks! I really appreciate your help, this was driving me up the wall.

While I'm here, if you wouldn't mind, I'm also having issues changing the color of the slices on the pie charts.

I can't find it anywhere in properties, nor can I find it when I open the chart editor, so I thought maybe I could just go around it with vba code. I've tried using "chartname.pallete" and "series.pallete", which I found after doing some searching, but those didn't work for me. I can't seem to find anything that tells me how to do this, so if you know how and could inform me that would be awesome.

EDIT

Ah nevermind, I got it. Thanks again

[isladogs]

Glad you found the answer for yourself.
Standard forum etiquette: please explain the method of changing the slice colours for the benefit of others who may find this thread later

[ItsRoland]

To Change the color of Pie Chart Slices:

- Open the report containing the chart in design view

- Double click on the chart, or right click -> Chart Object -> Edit

- Click on the slice of the pie chart you want to change the color of until its selected (took a few clicks before it realized what I was trying to select, which is how I missed this before)

- Right click the slice -> Format Data Point

The interface that opens allows you to change the color, as well as some other things.