I want to create a secondary axis, but when I go to chart area, format selection I only get Format Chart Area and no option for series option - plot...

Is there a toggle that turns off the auto-scaling of fonts in a chart, for 2007? My theory is that it was replaced by the "Character Spacing" tab. Did the...

I created a simple chart with two columns of data. Now, the chart icon is grey and I can no longer create a chart on this spreadsheet. Furthermore, when I...

Two questions really, all to do with this arduous Chart Range Edit Box. 1. Is there anyway to copy chart range sets so I can just take one line, duplicate...

I have a column chart with 2 bars in each catagory (total 12 bars, 6 categories). I want to put each data series on a separate axis. When I choose the...

Is it possible for Excel to automatically arrange the labels / series for a chart so they do not overlap? I create a pie chart from a timesheet report which...

I have a simple line graph and when I went back to it the dates in the date column had changed to sequential numbers eg. 39088, 39089, . . . and Date now...

Hello I have a workbook with about 45 charts in it. I have set up a menu so that users can select the chart they want to view by clicking on a hyperlink that...

Excel keeps changing my formulas to include nearby cells.

Hi, I have an embedded chart with a scrollbar and zoom objects placed on the chart. The chart appears on a worksheet where users input data, and the chart...

ng to openiHi I run Excel 2000 I have a workbook with a number of charts in it. These charts have data on 2 axis. The left axis has a bar chart with a...

I would like to move chart templates from a W2000/Office2003 system to a Vista/Office2007 system. I cannot find files that seem to be chart templates. Is...

I've created a series of horizontal bar charts and all the text labels to the left of the chart categories are centered. I want them to be right-justified...

I'm plotting data in a scatter plot. The data values span -1 to ~16,000 and I want them on the Y axis. I do not want to plot the -1 values. I've set the Y...

Hi, I have a chart that presents 2005, 2006, 2007 summary data as a column chart and then 2007 by month as a line. To show the yearly data I have a yearly...

I want to create a dynamic graph with dropdown selections for the varying data series. I tried: Defined series names using the top cell of each column,...

Hi MVPs, I'm stuggleing with formatting an excel pivot table correctly in excel 2007. Here is what i've got, a pivot table with hours as the values as...

Sometimes Excel files get incredibly big very fast apparently without adequate reason. Once big one seems to never be able to get them smaller again. Any...

I would like to change the default colors fot the lines and background in Excel charts. The default background is gray and wastes toner and the yellow...

I am having a problem editing an excel template which I managed to cobble together a while back. The template is a dashboard report. It contains one specimen...