ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Y Axis (https://www.excelbanter.com/charts-charting-excel/207131-y-axis.html)

Meejung

Y Axis
 
I am trying to create an average line using a line chart on an existing
chart. When I try to match the values from the Y Axis from my primary
request I change the scale but the numbers all default to percentages or
decimals based off the percentages. I can't get whole number to show up even
when I use the general or number tab. Can anyone help?

Thanks,
Meejung

ShaneDevenshire

Y Axis
 
Hi,

It suggest that you have fractions/percentage/decimals in the source range
if changing the format does not change the display.
--
Thanks,
Shane Devenshire


"Meejung" wrote:

I am trying to create an average line using a line chart on an existing
chart. When I try to match the values from the Y Axis from my primary
request I change the scale but the numbers all default to percentages or
decimals based off the percentages. I can't get whole number to show up even
when I use the general or number tab. Can anyone help?

Thanks,
Meejung


Meejung

Y Axis
 
Shane,

Thanks for the reply. I was actually using the wrong graph. I was using
the one for the percentages. It worked right when I used the right graph.

Thanks
"ShaneDevenshire" wrote:

Hi,

It suggest that you have fractions/percentage/decimals in the source range
if changing the format does not change the display.
--
Thanks,
Shane Devenshire


"Meejung" wrote:

I am trying to create an average line using a line chart on an existing
chart. When I try to match the values from the Y Axis from my primary
request I change the scale but the numbers all default to percentages or
decimals based off the percentages. I can't get whole number to show up even
when I use the general or number tab. Can anyone help?

Thanks,
Meejung



All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com