Excel 2007 problem with bar charts
I've turned some corner with charts in Excel 2007. Whenever I make a bar
chart it pops up a chart that has spindley little lines. It looks nothing like the charts that I've chosen. When I make pivot charts they turn out perfect. But when I choose chart types, my graph bars are thinner than the gridlines in the plot area. Do I need to reload MS Office 2007 to get this problem to go away? |
Excel 2007 problem with bar charts
Hi,
Is it possible that the x-axis is a date or time scale? If so try switching to Category for the axis. (Right-click the x-axis and choose Format Axis, Axis Options, and set Axis type to Text axis. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "jknapp1005" wrote: I've turned some corner with charts in Excel 2007. Whenever I make a bar chart it pops up a chart that has spindley little lines. It looks nothing like the charts that I've chosen. When I make pivot charts they turn out perfect. But when I choose chart types, my graph bars are thinner than the gridlines in the plot area. Do I need to reload MS Office 2007 to get this problem to go away? |
All times are GMT +1. The time now is 08:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com