Chart issue!

rfletcher35

Active Member
Joined
Jul 20, 2011
Messages
300
Office Version
  1. 365
Platform
  1. Windows
I have the following data with the graph below, I am trying to get it to read with 1 colour each for E,L, & N so the graph looks better. I hate graphs in Excel but i'm determined to nail them. Please help!!!!
WEEK OUT ORDER CANCELLATIONS PLAN CHANGE BE ABSENCE COVER HOLIDAYNON TRANSFER - CHANGETRAININGNON SUPPLY OTTOTAL ORDERTOTAL SUPPLIEDFAILED TO SUPPLY
ELNELNELNELNELNELNELNELNELNELNELN
Wk290916DENES 1727410400000001002320000000074771076676104813
DENES 269646718197171516000000000000000686076645875421
DENES 3474449000041407000000000000514857514857000
DENES 49090000001030000000000001001210012000
Wk031016DENES 197150000001040003200000001391913918001
DENES 2483162224000201000000000000482959492959-100
DENES 3496052005000262000000000000516649516649000
DENES 4190320000000000000000000001903217032200
Wk101016DENES 1252424003014349000000000000282934272831113
DENES 2395143122000000000000000000384941384941000
DENES 35760560021014514139000000000000818768818768000
DENES 4170330003057040000000000002704227042000
Wk171016DENES 1000000112132000000000000244244000
DENES 2402228004000100000000000000412224412224000
DENES 3644073000000206000000000000664079664079000
DENES 4180390003015030000000000002604326043000
Wk241016DENES 1734201233100000000000000017661766000
DENES 255719581416254002000000000000496285496285000
DENES 3384245000101101000000000000404247404247000
DENES 4140170000004010000000000001801818018000
Wk311016DENES 1120000000004000000000000124124000
DENES 2538065003000101000000000000548063548063000
DENES 3693671000002502000000000000743675743675000
DENES 42302600000110060000000000003303333033000
Wk071116DENES 176696945191518021000000010000737269737166013
DENES 2705162000031300000000000000735463725463100
DENES 3565257220101011000000000000555159555159000
DENES 4631000050134030000000000001532615324002
Wk141116DENES 13624559611723112000000000000352149352149000
DENES 2716389879000010000000000000635780635780000
DENES 3684573000300112000000100000734675734675000
DENES 435036109001112090000000000004604746047000
Wk211116DENES 1342000010000000000000000352122230
DENES 2364139000010000000000000000364239215344134
DENES 332324400010010000000000000034324491118252126
DENES 4000000100100000000000000200200000

<colgroup><col><col><col span="2"><col><col span="23"><col><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>




-- removed inline image ---
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,214,985
Messages
6,122,602
Members
449,089
Latest member
Motoracer88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top