Select 4th slice of pie-chart in Access 2003 report

Big Pat

Registered User.
Local time
Today, 18:31
Joined
Sep 29, 2004
Messages
555
I’ve got a simple dataset that will ALWAYS have 4 rows, against which I have assigned the colours Green, Amber, Red, Grey. So I made a simple pie-chart to go on the report, but I can’t work out how to assign the same colours.

Please see 3 attachments showing the current layout, the preferred layout (which I mocked up in Excel) and the chart settings screen.

The chart is “working” OK i.e. 4 slices appear and they are the right size, but when I open the chart, I see only East, West, North. So I’m unable to manually set the colour for the 4th slice.

Is there a way round this? Thanks,

Pat
 

Attachments

  • Current Access output.PNG
    Current Access output.PNG
    14.8 KB · Views: 120
  • Required output.PNG
    Required output.PNG
    19.7 KB · Views: 116
  • Chart settings.jpg
    Chart settings.jpg
    96.4 KB · Views: 111
I hate to bump, but...

Anyone have any idea how I can make that 4th slice grey?

Thanks
 
I use one of the below method, but I can't remember which one it is.

  1. Open the report in design mode, make some change in it, (move a control a bit, so you are been prompting for saving the report when you close it), then "Preview" the report, and close the report, save it when you are being prompting.
  2. Open the report in design mode, make some change in it, then "Preview" the report and save it before you close it.
  3. Open the report in "Preview" and then just save it.
After each of the above steps, open the report in design mode, to see if it change to your data instead of East, West, North. It is important you view it in "Preview" mode.

Else post a stripped version of you database with some sample data.
 
Hi,

Thanks for your advice. I have designed, saved and previewed the report several times, but nothing seems to make any difference. Or are you saying that it should be previewed within the Microsoft Graph screen somehow?

When the chart is open is design view, I can see THREE slices and I can use the toolbar to set the colours. But I still can't see any way of selecting the 4th slice. By default, it is light blue, but I need it to be grey.

I have attached a stripped database to illustrate the problem.

Thanks,

Pat
 

Attachments

[FONT=&quot]The only thing I did were open the report in "Print Preview" and then save it, ("File" -> "Save"), then the 4th slice showed up.
attachment.php

[/FONT]
 

Attachments

  • 4th slice.jpg
    4th slice.jpg
    69.4 KB · Views: 217
  • Test1.mdb
    Test1.mdb
    948 KB · Views: 104
Thank you for your help. I can see that you have made the 4th slice grey, but HOW did you do that?

In print preview I see 4 slices, but one of them is blue and I cannot see how to select it. In design view I see only 3 slices, so once again I cannot change the colour of the 4th.

I tried 'File' > 'Save' but it just saves the report with the blue slice. I also tried 'File' > 'Save As' but that just makes a copy of the report.

I must be missing something obvious, but I still really cannot see how I can make the 4th slice of the chart grey.

Pat
 
I don't know why it works by me and not by you, just for a test I downloaded you database 5 times and each time the 4th slice showed up, (also in design view).
Here is exactly how I did it:

  1. Download you database.
  2. Save it on the C drive.
  3. Double click on the database in the C drive, so MS-Access open with the database loaded.
  4. Open the report in design view.
  5. Then from the menu line/Ribbon choose "Print Preview".
  6. Then from the menu line/Ribbon choose "File" -> "Save".
  7. Open the report in design view.
I use MS-Access 2010 with Windows 8.

Try to download your own database and followed the step above.
Do you have the possibility to try on another computer?

Are the other members there could download the database and see if the above works, and then give some feedback here?
 
Thank you for your patience. I'm using Access 2003 in Windows XP professional, I wonder if that's causing a problem.

I'm confused though. When you first opened this database was that section of the pie-chart ALREADY grey? If not, which step changes it from blue to grey? You are downloading, opening, previewing and saving, but I don't see any step where you changed the colour.
 
Hi,

I've just tried this on another computer and it DOES work. Same office, same version of Windows and same version of Access but there must be something different on my PC.

You are completely right, I previewed the report again, went to design view and then the report had four slices (also with the right labels instead of East West North) so I was able to make the 4th one grey. Maybe I need to get our IT dept to re-install Access for me.

Thank you so much for all your help. I really appreciate it.
 
You're welcome, good you managed it at last, to view the 4th slice, (unfortunately not on your own computer). :)
 
Not sure how to post a new question; I was trying to search for how to keep colors consistent with the categories; seems like they change and I'm reading that the colors/categories are 'skipped' if the amount is 0. How do I get the category color to remain consistent with the category name.
 

Users who are viewing this thread

Back
Top Bottom