P
p7
I think I have stumbled upon a bug in Excel 2003. I routinely use Excel to
make graphs that compare several different series across hundreds of data
points. Only about 10% of my data points have actual names (randomly spaced)
and therefore only these points have a label that I want to place on the
horizontal axis (the rest I leave blank). Because there are so many labels,
Excel makes the default interval unit somewhere between 2-4 for these graphs
depending upon the number of data points. I want to display all of them (and
it won't look ugly and overlap each other because 90% are blank), so I set
the interval unit to 1. This has worked fine for a decade with Office 95
through Office 2003. Now with Excel 2007, even though I set it to 1, it
displays it as if the interval unit was set to 2. This is very frustrating.
Does anyone know how to properly report this to Microsoft? I can't find a bug
reporting website anywhere. I can send someone a file as an example that
looks fine when I open it in Excel 2003 but is wrong (missing labels) in
Excel 2007.
Thanks to anyone that can help!
-p7
make graphs that compare several different series across hundreds of data
points. Only about 10% of my data points have actual names (randomly spaced)
and therefore only these points have a label that I want to place on the
horizontal axis (the rest I leave blank). Because there are so many labels,
Excel makes the default interval unit somewhere between 2-4 for these graphs
depending upon the number of data points. I want to display all of them (and
it won't look ugly and overlap each other because 90% are blank), so I set
the interval unit to 1. This has worked fine for a decade with Office 95
through Office 2003. Now with Excel 2007, even though I set it to 1, it
displays it as if the interval unit was set to 2. This is very frustrating.
Does anyone know how to properly report this to Microsoft? I can't find a bug
reporting website anywhere. I can send someone a file as an example that
looks fine when I open it in Excel 2003 but is wrong (missing labels) in
Excel 2007.
Thanks to anyone that can help!
-p7