I have a number of charts "stacked" one over the other - the user can only see one at a time (done by VBA). Now I want to put a feature on the worksheet where...

John, Check your chart data for zero or negative values. On a log scale, that sends a point past all known galaxies (and doesn't stop there). -- Earl...

Have you tried saving the worksheet in html format? You can incorporate this html code into the web page. - Jon ------- Jon Peltier, Microsoft Excel...

Create a stacked chart with all the data including price. Then, select the price series on the chart. Select Chart | Chart Type... and select the kind of...

I am looking for further information on the R-squared value when dealing with the trendline of a chart. A description of what it is refering to and a break...

I thought I had a simple task to perform for work. Then, I tried charting it in Excel and have not had any luck. I need to take some simple data and for each...

How do I create data labels from cell data without downloading an add-in. I would like to create my own VB code but do not know how to call the data label...

Hi, My VB program uses Excel's built in custom type chart called Smooth Lines. I use the following code to call it: Excel.ActiveChart.ApplyCustomType...

Column A contains week numbers starting at Week Number 0 (ROW()-1) to a Week Number "n" and if the week number exceeds the numbers of weeks ROW()-1 returns...

It may be difficult to read with a month's worth of data, but you can do the following (using your sample data in cells A1:C6) -- - Add a column to the table,...

Hello All John Walkenback said in one of is articles on clickable images is to place a image and place transparent objects on the image and write event...

Product: MS Excel 2002 (English version) Table: Weight of parcel and its price Weight (kg) Price (=A3) 0 0 1 3.32 1.5 4.27 2 4.58 4 6.91

How can I make a chart with the data sorted by value ?

After loading data into a worksheet I generate 3 separate charts on chartsheets. The first and third charts are generated as desired and the second chart looks...

Does anyone know how I can select cells from multiple worksheets in the same spreadsheet and show the data in a chart?

Is there a formula or way to create a chart in Excel where the column chart will have the data in a single column separated instead of just a solid column?

Is there a way to print multiple chart sheets? When I select multiple tabs, I do not see the chart tab (in FilePage setup) anymore.

I have a line chart with 2 lines. Is there anyway to shade or change the color in the area between those 2 lines? Thank you

I have not figured out how to select the data for the secondary axis in a line chart in Excel 2000. The help menu states "On the Format menu, click Selected...

I have a question.......I know it can be done, but I was wanting to know if say, you have a grid chart made. How do you go about automatically numbering the...