Hi, I faced this problem and found a solution but you need to use macro. Sub AutoScaleYAxes() Dim ValuesArray(), SeriesValues As Variant Dim Ctr As...

I am trying to create a line chart but am having trouble with labeling the X-Axis. The graph is charting temperature on the y-Axis and the date and time of...

Hello,can anyone help me with solving problem how to create 3D chart probably bar chart with different bottom shape? I mean, where bottom part are not axial...

I am setting up a chemistry calibration curve using data below OD reading Concentration ..020 0 ..045 10 ..245 ...

Hello all, I have a MS Query in Excel filtering and retrieving relevant data from MS Access. When the data returns, all BUT the column which refers to a OLE...

Hi ... Have about 10 bubbles there. Need to format data labels of ALL 10 bubbles at the same time. (I wanna select Alignment label position center, that...

I have several charts on a worksheet. If I edit the plot area on one (resize it) and save/exit the file, the plot area of every chart, including the one I...

I need to update a series of pivot tables by adding 2010 data. What's the best way to do so? Add the updated info to the source document and refresh, or...

I have to create a char, that when clicked on will return the point of the click. PLEASE, noticed that I will be clicking anywhere on the plot NO on a SERIES...

I have a number of data points that appear to fit a negative exponential model. When I graph the data in Excel that is how it looks. However, the trends that...

Hi, Sheet2010 stores data for year...

in a chart in excel, is there a way to take one column and find out how many times numbers pop up. say numbers 1-42, I want to know how many times each of the...

Hi, On an XY scatter chart, how can I have two sets of intervals for the Y axis without doing a secondary scale? My data varies greatly and does not show...

hi, I am a mining analyst... I want to plot a column chart, sorted according to share price performance, but with the bars colored according to the commodity...

I have a user with an Excel chart of research data (over 20000 rows) that is to be placed in an Excel chart and inserted into a Word document. As you can...

At the beginning of the code I blow away any chart objects I find with Dim co As ChartObject For Each co In mySheet.ChartObjects co.Delete ...

Hi, What do you suppose is the best timeline template and/or add-in for Excel or Word 2007? It should extend into the past and fututre. Thanks much, ...

Hi Team, I have a column of countries with their associated data (eg population or GDP etc) in the next column and am wanting to plot the bar column heights...

Sample scenario: Let's say in each year, I have this many cats: 2010: 6 2011: 8 2012: 20 Out of those cats, let's say that the following number have been...

Have a column chart in which the same label applies to two adjacent columns. Rather than have it redundantly redisplay the labels I adjusted the tick mark...