I have a large workbook with about 30 charts each on a seperate worksheet I manually name the charts be changing the tab names. sometimes when I reload the...

I'm creating a large workbook with master data on one page and on all following pages Pivot Tables with associated Pivot Charts, one worksheet per state, 4...

Help! I want a line chart that only shows data points, not lines in between. A scatter chart doesn't work correctly with the data. How do I remove the...

All, I need some help plotting in Excel. I thought I knew something about this charting stuff but now I'm stumped. I tracking my investments at random dates...

How do I create a chart which shows both a total number of bookings & the total revenue matched against months of the year. e.g: Months Total Bookings ...

how can i add trendline or best fit line on a scatter plot which has multiple set of data. for example, i had 3 set of data for 3 different depth (0cm,15cm and...

In excel 2007 my charts are displayed when inserted in a a sheet but they do not show when moved as separate tabs

Hi. I am trying to create some "MARKERS" at the top of a line chart. I'm using a series as a line to mark the top of the graph. The purpose of the markers...

Excel charts are not visible when they are located in chart sheets. They become visible when certain printer drivers (e.g. Microsoft Office Document Image...

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 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'm creating a graph from a series of values in one column. In the adjacent column I have the date the value is entered. How can I get these dates to...

I copied text, values and formulas from one workbook to another. When I tried to chart some of the data, the chart insert chices were grayed out. It...

how to create a plot from separate x and y values. i.e. y values do not correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15

I have 25 charts based on dynamic ranges and featuring links to other workbooks. My question is actually twofold:- 1. The charts all update themselves...

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...

How can I put decimals in my pie chart - such as 98.34%?

Hi, I have a lot of data in which sometimes data varies too much that some bars raise up to 1000s and some remain within 100s. now, to overcome this problem...

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 ...

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...