I am trying to visually represent different conditions on a line chart (e.g. underlying data is rainfall in the UK; plot as a dashed line. The conditions...

Good afternoon everybody, is there a web site and or someone that could help me in setting up,step by step a 3D Funnel Chart? Thank for the help Giovanni

Hi - I am creating a manpower report and updating learning curve charts for a decision making tool through VBA. The issue I am having is the trend...

I need a way to use fill type to distinguish columns in a column chart for a black and white publication. Ideally, this would be the traditional horizontal,...

Hello, I have 100 series on my spreadsheet and I need to make a chart for each one. How do I make it in one shot? I have data ordered in four columns A to...

I have four dashbards each with 4 charts containing macros, and each in it's own workbook. The data for the macros is all in the same workbook. It works...

How can I create "Name" that will enable a dynamic stock chart in Excel 2003. I have been able to create single series dynamic charts using "Name", but no...

XL 2007 doesn't have the TOOLS-Options-Interpolate menu and choices. This goes for a line chart as well. Thx

Has anyone encountered this? TIA - Bob Sub ColorBySeriesName() Dim rPatterns As Range Dim iSeries As Long Dim rSeries As Range Set rPatterns =...

I want to create a chart where the areas under the baseline are a different color than the areas above the baseline. Is that possible?

Hi there, I have many charts that are updated on a weekely bases (52 weeks) however currently I am going in manually and changing the cell rangers to update...

Hi again, I'm trying to use VBA to: - copy a chart in a chart sheet - paste it as an embedded chart in a new sheet - resize (and format) the chart - copy the...

I'm trying to set up a dynamic Data Source. I've read Jon Peltier's example of creating a named range with offset, but for some reason Excel says my named...

Okay, I'm sure I'm not using the correct language while asking this question, so bare with me.... I have a bar chart plotting volume numbers for each package...

In Excel 2007 if you create a XY Scatter Plot and then add a polynomial trendline to the plot, display the equation, then try and copy/paste the chart to a...

Hi, I would like to add some pictures as data markers in my line chart using excel VBA. I tried recording a macro to do this but the code is not generated...

Hi, In the chart of excel, there is one type called line with markers displayed at each data value. Because my data values are lots, in my chart, markers are...

Hi, I'm trying to plot a chart with more than 800 series. The problem is that I want all the series to have the same format(color, weight and line type). I...

I wonder if this is possible: I have an array of data of Latitudes/Longitudes with the cell value being Altitude (DEM). With condformat I have painted the...

I have a database where column H2:H89 are the prices homes sold for during a given period. I would like to create a bar chart with each bar representing a...