Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a "0" appear on the Y-axis of my graph?
I have an unconventional y-axis, with values of 2, 7, 12, 17 and 23 on my
y-axis in my chart. This was used to bring out the importance of the data. However I now wish to have the y-axis show a 0 too, how do I do that while keeping my unconventional axis values? Would appreciate any help! Thank you! :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a "0" appear on the Y-axis of my graph?
Dummy it up.
Either add a textbox that contains a zero and position it appropriately or add a dummy series that contains the desired values and show its datalabels. For an example that you can adapt, see Flexible Log Scale http://www.tushar-mehta.com/excel/ne...ale/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have an unconventional y-axis, with values of 2, 7, 12, 17 and 23 on my y-axis in my chart. This was used to bring out the importance of the data. However I now wish to have the y-axis show a 0 too, how do I do that while keeping my unconventional axis values? Would appreciate any help! Thank you! :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a "0" appear on the Y-axis of my graph?
Right click on the y-axis data on the chart, left click on "Format Axis...",
click on the "Scale" tab. I haven't had to try this, but if you click on the box to the left of "0" this should display a "0" on your y-axis. "magikid" wrote: I have an unconventional y-axis, with values of 2, 7, 12, 17 and 23 on my y-axis in my chart. This was used to bring out the importance of the data. However I now wish to have the y-axis show a 0 too, how do I do that while keeping my unconventional axis values? Would appreciate any help! Thank you! :) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a "0" appear on the Y-axis of my graph?
Thank you very much for both your suggestions :)
"chemist" wrote: Right click on the y-axis data on the chart, left click on "Format Axis...", click on the "Scale" tab. I haven't had to try this, but if you click on the box to the left of "0" this should display a "0" on your y-axis. "magikid" wrote: I have an unconventional y-axis, with values of 2, 7, 12, 17 and 23 on my y-axis in my chart. This was used to bring out the importance of the data. However I now wish to have the y-axis show a 0 too, how do I do that while keeping my unconventional axis values? Would appreciate any help! Thank you! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Updating a graph with 2 y axis | Excel Discussion (Misc queries) | |||
how do i do x/y axis graph | Charts and Charting in Excel | |||
why do my graph axis titles become truncated | Charts and Charting in Excel | |||
How do I add a second axis to a graph with 2 data series? | Charts and Charting in Excel |