Why are my percentages wrong in Excel

I don't know what's wrong and unable to figure it out by myself, the percentage value is predefined in the sheet itself, but still, it is displaying the percentage in the wrong for

Why are my percentages wrong in Excel

I don't know what's wrong and unable to figure it out by myself, the percentage value is predefined in the sheet itself, but still, it is displaying the percentage in the wrong format.when I click on it which renders it further line chart and so on, the last phase showing the data right way, I can't figure out what's wrong with first two, even if I change the order, it always shows the data right for the last one.

the percentage value on theline chart looks like this:......

Screenshot_1.png

and nothing special about data.it simply looks like this:...YearMonthDistrictPrivate HospitalPrivate Hospital %Govt. HospitalGovt. Hospital %Total2012JanuaryAjmer000002012FebruaryAjmer000002012MarchAjmer000002012AprilAjmer000002012MayAjmer000002012JuneAjmer000002012JulyAjmer000002012AugustAjmer000002012SeptemberAjmer000002012OctoberAjmer843187.8117212.296032012NovemberAjmer755984.85135015.1589092012DecemberAjmer840983.48166416.52100732013JanuaryAjmer825284.26154115.7497932013FebruaryAjmer833284.17156715.8398992013MarchAjmer903384.83161515.17106482013AprilAjmer946982.24204517.76115142013MayAjmer956878.19266921.81122372013JuneAjmer1031082.23222817.77125382013JulyAjmer1112380.2274619.8138692013AugustAjmer976781.43222818.57119952013SeptemberAjmer961579.5247920.5120942013OctoberAjmer922278.62250821.38117302013NovemberAjmer924681.2214018.8113862013DecemberAjmer913279.28238720.7211519


please, guide me through how to get it done.

Thanks in Advance

Video liên quan