Excel has the option under Tools - Options - Chart tab Plot empty cells has - Not plotted (leave gaps) - Zero - Interpoloated i cannot find the...

Help sais: Display cell contents in a shape or text box Click the AutoShape or text box you want to link. In the formula bar, type an equal sign (=)....

I have created a PivotTable using data in another spreadsheet. For some reason when I try to sum the data in the Data Field, all the values turn to zeros. ...

I am trying to graph the delivery of pipes for a pipeline. Y being date of delivery, x axis showing mile post. data is to show a line the length of pipe...

How can I allocate which data series I have against which y axis? I have four series: 3 numbers (axis 1) and want to allocate my fourth series (%age) to axis...

Hi I would like to use a time axis to start at 1st January 1999, end at 20th August 2008 and mark every 1st of the interim years with the number of the year...

I need the bar colors to change after reaching ONE particular point. how do i do that? I have searched the many different posts or threads, they all seem...

If I have a pivot table with the following info: County, date, and lot #'s sold by county; how can i sort this horizontally so that the counties go across...

I've created a stacked column chart but the columns are very thin - the chart looks like a bunch of thin lines. Is there a way to widen the columns? Paul...

To be more exact, I require my original data labels (in an Area Chart in Excel) to remain visible, ie £250,444; in addition I require to show on the same...

Hi there, I am doing a simple line graph for data points over 200 days, however for some of the days I do not have data, therefore when I create a graph it...

Hi All: I have 10 years worth of currency data that i need to graph by month. Many months do not have any data - adding a "zero" makes the line plummet to...

This is a probably one of the simplest questions but I'm just starting to chart again. I have entered a category title "year" in cell A1 and entered from...

HI i have a chart linked to source data (10 days history with a number beside each day) . I entered a worksheet formula to automatically show previous 10...

I have used an IF formula to replace blanks, zeroes etc. with #N/A as I thought charts ignored this. My source data is 2 columns as below displaying as a...

Charts that I have generated using an Access macro display the legend on top of the plot area. Attempting to format the legend area - including toggling...

I recently installed Office 2007 and my charts that have a primary and secondary vertical axis now has the secondary axis just to the left of the primary. I...

Hi, I would be extremely grateful for some help with my spreadsheet. I have the following data which I need to use to produce charts for a hospital report...

I am trying to select data for a bar chart. In Column B i have one of two labels: ES or ZN. I would like the bar chart to plot only the values in...

I have to do two bar charts, one is a comparison of male and female IT skills the second is a comparison of male and female IT skills training wanted. I have...