When combining text and data in a cell, I loose the format of the data. How can I specify the format? As an example, my cell is: ="Growth: "&AN33 but the...

I personally use an add-in (.xla) which includes the following code (you can pick up the size of a chart with ctrl-shift-d and apply it to another chart with...

Hello, I am trying to make a graph that would show the sales for the US and overlapping would be sales by area. I have a presentation to do for the area...

I have a chart that I have developed that I use for reporting. The chart is updated automatically with the necessary information. I would like to insert...

Unfortunately, the BMSLtd.co.uk domain name is no longer under the control of Business Modelling Solutions Ltd. I no longer have any affiliation to that web...

Hi guys, xl97 question. Is there a way to have data labels enabled** for all points plotted but with the labels automatically *excluded* for any zero values...

I would like to know how to edit the legends for a chart. Have tried various things -- right click on the legend, but nothing seems to work.

How do you create bar-of-pie or pie-of-pie charts? I have tried sorting and arranging the data in different ways but cannot get it to work.

I have the following data in a table A $40,000 B $89,000 (70% spent) C $63,000 D $74,000 I want to show that 70% of slice B has been spent....

I can change the default colors for fills and lines in excel charts. This is done by going through Tools:Options:Color. If you want to make the colors default...

Hi, I would like to enter values into a Chart from a Named Array(Range). The Array should not be an actual Range, but a virtual array based on logic applied...

You could create your own custom chart type. Jon Peltier has instructions in his Chart Types...

I have a project where i have to chart the compliance of three groups over a number of months. So for each data set there is a Compliance#1 stacked...

Hi, I am creating a pivot chart and then altering the colors, alignment etc. However, everytime I change a parameter from drop down lists, the colors default...

Hello - I am trying to chart the following and I would like for someone to give me an example of how they might put this in a graph. I am totally new to doing...

Hello, I wanted to make a couple of changes in the formula for the y-axis and cannot get the graph to update the changes. any assitance is appreciated Jason...

How to assign short cut keys to paste special in excel 2000

Hello, This is a Inventory life tag label and I use following code for print how many labels as I want. Option Compare Database Option Explicit Dim...

1) Select the 6 columns of data 2) Make a Column chart (Bar charts have x-values vertically) 3) In the chart, right click on the data for a series to be made...

I am running Excel 2002 and Windows XP server on a network PC. When I generate a scatter plot and attempt to re- format the axis titles, the active text boxes...