How do you display negative values in a waterfall chart? Everytime I have a negative value in my data, the bar disappears off the chart.

I created chart with timsescale as catergory type ..Axes(xlCategory, xlPrimary).CategoryType = xlTimeScale...

i am still using the Excel in my Office 200 package. Where can I get udates to do better charts?

Hello. Is there a way for pivot tables to count a field only if it contains a string of characters? Example...

I have Excel 2007 and so far have been quite pleased with the improved chart graphics. We have a set of data and would like to apply a color map to it IN...

Hi, I have two pivot tables in the workbook and a macro button to refresh the tables. We've uploaded the template on the web browser for users. My problem...

Hi, I have problem with a macro that creates chart gallery. I have a chart gallery file as gallery.xls. I write all the charts from this gallery to...

Hi, I have a simple pivot table with two columns A and B against several rows of responses. The pivot table also shows the Grand Total Column. I can graph...

Thanks in advance to anyone that can help me or tell me that this isn't possible. I have a chart that has 3 series in it. It is a reach and...

I am at wits end; I am building revenue/profit projection charts from a very complex Excel spreadsheet. Due to the complexity, I am unable to simply click...

Does any one know of an add-in or macro that will allow the goal seek ability on a data point to work in excel 2007 the way it did in the prior versions of...

Where do you differentiate if you want vertical or horizontal error bars? When I go to more options and select custom, it always chooses either ...

I have a user who's unable to paste an Excel 2003 chart into Outlook 2003 email message. In Outlook options, the checkbox is selected for "Use Microsoft...

I have a bar graph with two axis. On axis x the bars are showing and there are no data labels. On the y axis the bars are hidden and there are data labels. I...

Hi, I wish to find out how many times"1.8" appears (column 'J') each week this year using dates in column 'B'. I have a formula which returns the total number...

Excel 2007 (running in Vista) is not always displaying the correct equation for trend lines added to Scatter Charts under certain circumstances. If you add a...

Hi, I have a chart with bars and two lines but I want to add another line on top of what I already have...can I do this if so, how? I have tried many things...

Hi All I have a bar chart with different percentages displayed as the columns. Or target is 70%. Is it possible to have a target line added to the bar chart...

I have created a line chart from the data source that contains either blank space or is null. I tried to remove blank space or cell has value is null from...

I have 70 subtasks under one task. Each subtask is the same task performed every day for 70 days. None begin until the previous one has been completed so...