I have a cash projection spreadsheet with a linked line chart. In the projection sheet, the font goes from black to green when the data goes from actual to...

Excel worksheet with rolling data each week - columns E thru M. Chart is linked to worksheet . How can I keep the data source in chart constant? JJ

I have several columns with data. In one column I do not have data for every row. In the line charts, those "zero" values are plotted and connected with the...

I would like to combine stacked percentage columns on the primary axis with lines on the secondary.

I created a bar chart in Excel and when I go to Chart Opens, I can add the value of each bar in as a data label but the percentage choice is grayed out. How do...

I can't figure out how to create a simple supply & demand line graph in Excel. Has anyone figured this out?

I have a very basic graph with lots of excess white space I can't get rid of at the bottom. No resizing bars appear any where except for the entire plot...

Hi every one...i've been racking my brain out on this one. I'd like to come up with a way to display things better. Background: I am making a running...

Excel 2007 doesn’t show Y-axis accurately when the values are small (eg. In the order of -14th ~ -15th). You can duplicate such behavior simply by...

Hi again, I'm trying to use VBA to: - copy a chart in a chart sheet - paste it as an embedded chart in a new sheet - resize (and format) the chart - copy the...

I have built large workbook of software test metrics for dozen of products (by rows) with results organized by week over the columns. I have created dynamic...

I have a standard column chart, and want to move the y-axis labels from the left side of the chart to the right side of the chart, but cannot change type of...

I would like to add data from one or more x-y scatter plots to another x-y scatter plot. I have several plots containing data each representing a small map. I...

I have a chart made up of bar and lines at the moment. But on one of the bars we would like to show another figure - as in a stacked - is there anyway I can...

I have a line chart with positive and negative numbers as 'Values'. My x-axis legend (the 'XValues') appears in the middle of the screen - along the x axis. I...

I'm looking for an automatic way to format the value axis with the least number of digits possible after the decimal. I want the format to switch from #,##0 to...

I have developed a nice dynamic chart with a combo box and check boxes thanks to those on this list. I do not have a pivot table. Is there a way to have the...

I have run across an issue I can't seem to get a handle on. I am trying to track sales across three regions on a weekly basis using a column chart. Below is...

I am going to assume your x-values start in A2, y-values in B2, all on Sheet5 Use Insert|Name|Define and define MyX...

Hi - select the title textbox - click in the formula bar (Important9 - enter the formula directly in the formula bar (NOT in the...