 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / January 2008Chart Axis
Using Excel 2003 I am charting some data that has a large range in numbers. I'm using a clustered column chart that compares values across categories. The chart has 4 categories of numbers to chart monthly. The problem I'm having is - in one category, the raw data numbers range from 2000 to 4500 and another category ranges from 25 to 90. When I chart this data, I cannot really see much of a bar in the chart for the smaller values. I want to at least have some bar showing. The minimum on the scale is zero. I thought to change the scale (Y Axis) minimum to a negative value and that didn't work. I also thought to show each number value and there's not enough room for that. Does anyone have any suggestions? ANY help would be greatly appreciated, Karen Hi, You have 3 choices that come to mind: 1. Use two Y-axis - easiest 2. Use a log scale on the Y-axis - may not be appropriate 3. Create a broken Y-axis. - hardest, see Jon's web site. peltiertech.com/Excel/Charts/index.html Cheers, Shane Devenshire > Using Excel 2003 > I am charting some data that has a large range in numbers. [quoted text clipped - 9 lines] > > ANY help would be greatly appreciated, Karen Thanks - This is a great Web site on charting! What's the best way to set up two Y-axis? Thank you again, Karen > Hi, > [quoted text clipped - 21 lines] > > > > ANY help would be greatly appreciated, Karen You need at least two series. Select one of your series, press Ctrl+1 (numeral one) to format the series. On the Axes tab (XL 2003 and earlier) or on the first screen you see, where given a choice between Primary and Secondary, select Secondary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Thanks - This is a great Web site on charting! > What's the best way to set up two Y-axis? [quoted text clipped - 34 lines] >> > >> > ANY help would be greatly appreciated, Karen Hello Jon, I love your Web site - It's very informative! I followed your instructions and when the "Format Data Series" dialog box displays, there is no "Axis" tab. I thought that I was doing something wrong, so I went to help and found this: When the values in a 2-D chart vary widely from data series to data series in a 2-D chart, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated data series. 1. On a chart sheet or in an embedded chart, click the data series that you want to plot along a secondary value axis. 2. On the Format menu, click Selected Data Series. 3. On the Axis tab, click Secondary axis. I followed this as well and I still don't see an "Axis" tab. Is this an add-in or something? Thank you, Karen > You need at least two series. Select one of your series, press Ctrl+1 > (numeral one) to format the series. On the Axes tab (XL 2003 and earlier) or [quoted text clipped - 46 lines] > >> > > >> > ANY help would be greatly appreciated, Karen What version of Excel is this? Also, some chart types are not amenable to secondary axes. Any chart with 3D effects will not support secondary axes. This is only one of many reasons not to use charts with 3D effects. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Hello Jon, > [quoted text clipped - 77 lines] >> >> > >> >> > ANY help would be greatly appreciated, Karen Thank you for your help. I'm using Excel 2003 and I'm also using the 2D chart. > What version of Excel is this? Also, some chart types are not amenable to > secondary axes. Any chart with 3D effects will not support secondary axes. [quoted text clipped - 88 lines] > >> >> > > >> >> > ANY help would be greatly appreciated, Karen Which kind of 2D chart? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Thank you for your help. > I'm using Excel 2003 and I'm also using the 2D chart. [quoted text clipped - 99 lines] >> >> >> > >> >> >> > ANY help would be greatly appreciated, Karen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.