Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Using Excel XP. I have a simple X & Y line graph which plots some numbers (y axis) with some months (x axis) At present I have January to December and only Jan and Feb have values next to them (both 0.4) - the rest have a #DIV/0! because the figures have not been entered - not that this should cause a problem, it never has before. On the Y axis, the values start at 0 and go up as follows - 0.1, 0.1, 0.2, 0.2, 0.3, 0.3, 0.4, 0.4, 0.5 This can't be right, surely - it is all set to auto so why are some values repeating, all my other graphs are fine. -- fuzzyfreak ------------------------------------------------------------------------ fuzzyfreak's Profile: http://www.excelforum.com/member.php...o&userid=14655 View this thread: http://www.excelforum.com/showthread...hreadid=519657 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() format the numbers to 2 decimal places to establish if it is a rounding problem -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=519657 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi Robert, yes I beleive it is. Thaks very much for your help. -- fuzzyfreak ------------------------------------------------------------------------ fuzzyfreak's Profile: http://www.excelforum.com/member.php...o&userid=14655 View this thread: http://www.excelforum.com/showthread...hreadid=519657 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I can't figure out how to add values based on font color. | Excel Discussion (Misc queries) | |||
Move the Y axis below negative values | Charts and Charting in Excel | |||
help me on rearrange cells based on its numerical values without repeating any number | Excel Worksheet Functions | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Looking for a way for excel to count unknown repeating values? | Excel Worksheet Functions |