I know there must be a relatively simple solution to my challenge, short of creating a new series od data which is the sum of desired series. Let's say that...

Hello, I have data that includes alot of fileds but my pivot table has PO, PO line, Vendor, and value. I need to sort the top 10 values by PO and line item. I...

When using Excell 2007, when I create a graph and place it in a new sheet, it works fine. But, what I'd like to additionally do is create another graph and...

I have data that I want to put in a simple line graph: The data is A B 23 200 87 500 I mark the 6 cells, select insert chart / line...

I have a chart showing numbers between 50 & 250 for hours used, I also want to add in % complete but only show the data labels, I want the data labels above...

I am using a set of merged cells as a data source for a line chart. However, I am getting empty/null entries as part of the data set from the merged...

I have made a bar chart but the axis descriptors are not aligned with the bar. What I mean to say is they are not in the middle of the tick marks How can i...

I have a worksheet with ten charts on it. I need to copy the worksheet with all its data and related charts to new sheets or files so I have a page for every...

Workbook currently being developed in 2003, but will be used in both 2003 and 2007. I have a chart that has dynamic (named range) sources. Users can pick the...

My chart has four data series. They all plot as the same kind of line and they all plot against the same axes. Series 1 - 4 must be listed in the legend in...

I have a stacked column chart I created last week with three data series. I added a fourth series today. I have data labels on the original three, and tried...

I have a simple spreadsheet with multiple rows and columns. Columns contain: Date, Text, and numbers. The information in the rows must be the same after...

I am having a dual problem: 1. On a scatter graph I can't get the trendline equation to update when the trendline itself moves (ie I am using the worksheet as...

Hi, I hope someone can help. I can automate a chart given 1 x- and y- axis. However when I try to apply the same offset principle to a chart w/ an x-axis...

Good day all, I hope someone can help me on this. I have a table : Product Sales C 10 A 7 B 5 D 2

On the "Font" tab of axes, chart title, text boxes, etc., is there a way to make "Auto scale" be unchecked by default? It's really annoying having to select...

Hello May I please ask for your kind help? I have 5 variables - a, b, c, d, and Fitness. When I create a Pivot Chart, with Fitness=height, I obtain...

Maximum number of data series is 255 in Excel. I am using Excel 97. Is there a way to go around that? I have more than 255 series and I want them to be on one...

i have a line chart that is being updated every day. I am trying to find a way to display the last day's value and this one only without having to manually...

My ledged say: Series 1 Series 2...I would like it to say: Percent Dollars. Is there a way to change the wording on the legend. My chart has 2 Y...