How Can You Fix - Dynamic Pie Graph colours?
Dynamic Pie Graph colours
Hi, I have set up three dynamic Pie Graphs from following online examples, these ignore zeros and build graphs, works a treat.
The snag is excel uses different colours for segments that have the same title, I can manually recolour these but I was wondering
if there's a way around this.
Say I have a table as follows;
Label Group A Group B Total
Apples 1 0 1
Pears 0 2 2
Plums 3 3 6
Grapes 0 0 0
Oranges 2 0 2
Peachs 0 2 2
Bananas 1 2 3
I then have three pre graphs formed from Group A, Group B and Total, The pie graph for groups ignores the zeros, but next month when the data is updated, some zeros may now be numbers, the pie graphs then add the additional labels but a different colour for
segments occur between the three graphs.
So is there a way of insuring Apples would always be automatically coloured Green, Pears Yellow etc etc?
I hope that makes sense.
Solutions to the Problem Dynamic Pie Graph colours
You could run a macro to ensure that each category will have the same color in all charts.
Dim cho As ChartObject
Dim ser As Series
Dim i As Long
Dim c As Long
For Each cho In ActiveSheet.ChartObjects
Set ser = cho.Chart.SeriesCollection(1)
For i = 1 To ser.Points.Count
Select Case ser.XValues(i)
c = 3
c = 4
c = 5
c = 6
c = 7
Case "Peachs" ' Peaches
c = 8
c = 9
ser.Points(i).Format.Fill.ForeColor.ObjectThemeColor = c
Windows Restore - Totally Fix All Errors including Dynamic Pie Graph colours
- Click on the Start button on the Taskbar.
- Type "System Restore" (without quotes) in the Search box and hit Enter or,
- Click on System Restore (when you see System Restore pop up in the list of search results).
- Make sure the "Recommended restore" radio button is checked on the restore utility window.
- Click on Next and follow the instructions given.
Note: There is the option on the restore utility to select "Choose a different restore point". Unless you have a specific reason to select a different date and time than what Windows recommends, just select the recommended option stated in the steps above. If you choose to select another one, follow these steps:Click on that desired date and time, and Windows 7 will perform a scan for any affected programs in that restore point.
Once completed, click Next and follow the instructions given.
Once you have selected the restore point, your system will start the restoring process, after which you will have to restart the system.
Recommended Method to Fix the Problem: Dynamic Pie Graph colours:
How to Fix Dynamic Pie Graph colours with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will scan your system. The errors will be shown in the scan result.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. When the Fixing part is done, your computer has been speeded up and the errors have been removed
Related: Cascading/Synchronized Combo Boxes In Word 2010,Change The Icon Of A Task Bar Item.,Changing Shell In Registry Has No Effect.,Change The Colour Of A Macro Button,CHKDSK PROBLEM-INSUFFICIENT DISK SPACE TO RECOVER LOST DATA-HELP PLEASE!,Configuring Updates: Stage 2 Of 3 - 100% Complete. Do Not Turn Off Your Computer. Don't Know What To Do Next!,Computer Goes To Sleep Mode When Left Idle And Does Not Wake Up.,Computer Won't Check Disk Or Defragment,Computer Restarts Without Any Reason. A Survey, Consisted Sequintes Errors: BCCode : 24 BCP1 : 001902FE BCP2 : F78BEA58 BCP3 : F78BE754 BCP4 : F7B7C1F3,Computer Froze When Performing Check Disk After Receiving Blue Screen Error,Dell XPS Laptop 'PRESENTATIONFONTCACHE.EXE' Using 70% Of CPU.,Dates In Mail Merge Between US And UK Versions,Data Validation - Is It Possible To Select More Than One Item At A Time? Like A Filter.,Custom Message Instead Of #DIV/0!,Defrag At Windows 7,How To Use Ezine Advertising To Increase Traffic To Your Website,Simple, Quick Ways To Increase Your Vacation Rental Revenue,The Nature Of Herniated Disc Symptoms,Just How Safe Are Britax Car Seats?,How To Distinguish Quality Mezzanine Level Design
Read More: Fast Solution to Problem: Double clicking .xlsm files open in Excel 2003 even though Excel 2010 is installed - Citrix,How to Fix - Display All Data with using a data validation?,Fast Solution to Error: drive will not defragment - stops analysing at 61% and will not go any further,Troubleshoot:DRIVER IRQL NOT LESS OR EQUAL (igdkmd64.sys) Help please Error,How to Fix - during indexing i had a power failure.now programs are gone or won't work?,Deleting Favorites from IE 8,d1.openx.org cookie removal from from temporary internet files cache,Data Validation & lookup,Disk Defragmenter Hangs at 31% analyzed,Downloading Windows7 Backup files from Windows which is currently still running since 10pm and found the rewritable Backup disc ran out of space as a complete Backup Disc Drive