Got an odd one here. I have suite of macros that create a workbook with a number of sheets, containing charts from a number of separate workbooks. The charts...

My macro tells me it can't set the ChartTitle. "Unable to set the Text property of the ChartTitle class". Any help. please? Ed Sub...

Hello, How to I hide and lock the formulas that appear on A1 to A10 let's say, without locking them? I need to be able to copy and paste the results so I...

Help! I can't resize an axis title on my computer. I can do so in the same file on other computers which have the same version of Office. What setting do I...

I have created graphs in a worksheet on excel 2003 and I want to merge them all onto one graph - there are 5 in total, each shows a range of job types on the...

ok, whenever I create a charten in excel 2007 (beta 2) it draws the chart and then the screen goes white.... not even the title bars, minimise buttons......

I have created Pie charts from the pivot tables in Excel and have selected my own colours on the pie charts. However, when I select Refresh Data from the...

Hello all, I created a Bar and Line Charts by using the technique of combining a bar and XY scatter plot. (I refer to...

I am trying to set up a chart from data in an excel spreadsheet, but am having difficulty thus far. I have a cell values as follows: w41 = total...

Hello all experts here, I would like to create a chart with two bars and three lines. But it seems if i input more than 4 types of data, the excel only...

I have a chart that I created from a pivot table. Instead of creating 40 plus charts individually, I tried to copy the original chart and change the...

I'am trying to make an Area Chart and I want the series to be transparent, but when I try to change this option in "Fill Effects" menu, its disabled. How can...

I need to create a line chart on vehicle testing. The chart includes several temperatures and pressures - and engine RPM. We stepped the RPM up and down a...

I am using Windows XP, and Microsoft Excel 2003. I have been asked to create scorecards with charts displaying rates graphically, and an attached table...

Post title: Problematic chart issues in Excel 2007 Post date: 9/29/06 MS office version: (12.0.4017.1004) MSO (12.0.4017.1003) BETA. Program: Excel Problem:...

I have an XY scatter graph with some points in it. My data in the spreadsheet looks like this: Data 1 | 10 | 10 | 1 Data 2 | 33 | 44 | 5 What I want to...

I have a bar Chart running showing calendar days available to a 'point' and I have to increment this manually so that it shows from the current date. Does...

I have a chart this is based on a Pivot Table. I go into the chart and change the colours into something a bit brighter than the standatrd coulour, but when...

I require a weekly/monthly planner for driver's journeys some of which occur on a regular basis

Hello - I need to create a 'dynamic' chart, with plotted data being 'chosen' by the user. Let's use this example: Say my company sells 9 models of shoes:...