Line Chart Incorrect Data Display

Gingerly · External Since: Oct 05, 2009 Posts: 2

My data in the worksheet cell is '100%' - on the chart is plotting '118%'.
Please help. Thanks!

Andy Pope · External Since: Mar 23, 2007 Posts: 174

Hi,

Not a lot of information to go, but try checking the line chart is not of
the stacked variety.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Gingerly" <Gingerly.RemoveThis@discussions.microsoft.com> wrote in message
news:622B754D-1EB7-4DD1-8442-9628B3DD8C54@microsoft.com...
> My data in the worksheet cell is '100%' - on the chart is plotting '118%'.
> Please help. Thanks!

Gingerly · External Since: Oct 05, 2009 Posts: 2

Hi Andy
Thanks so much for your quick response but I had read through the threads
and had already checked to see if it was a stacked linear chart. It was not.
I resolved the issue but probably not in the best way. When I clicked to
edit the Y axis, I saw that the maximum field was set to 1.2 so I just
uncheched that field and changed the value to 1.0 and it seemed to work.

"Andy Pope" wrote:

> Hi,
>
> Not a lot of information to go, but try checking the line chart is not of
> the stacked variety.
>
> Cheers
> Andy
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "Gingerly" <Gingerly DeleteThis @discussions.microsoft.com> wrote in message
> news:622B754D-1EB7-4DD1-8442-9628B3DD8C54@microsoft.com...
> > My data in the worksheet cell is '100%' - on the chart is plotting '118%'.
> > Please help. Thanks!
>
>