You are here:

Excel/Expert Profile


Ask A Question

Jan Karel Pieterse

Netherlands
Available

Follow me on:
  

Expertise

Excel and Excel/VBA questions

Experience in the area

Excel MVP

Organizations

Self employed Excel developer

Education/Credentials

Bachelor in Chemical Engineering

Awards and Honors

Microsoft MVP award since 2002

Past/Present Clients

Shell, Fortis bank, ABN-AMRO bank, Morgan Stanley, ...


This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Richard01/10/17101010 
Bimmy12/12/16101010 
Michelle09/08/16101010Hi Jan, this works perfect. I am .....
Prashant S Akerkar 08/29/16101010Dear Jan Thanks. Prashant
Prashant S Akerkar 08/29/16101010Dear Jan Thanks. Prashant

Recent Answers from Jan Karel Pieterse

2017-01-11 Chart appearance.:

The entire routine should read:    Sub SaveCharts()      Dim oSh As Worksheet      Dim oCht As ChartObject      For Each oSh In Worksheets          For Each oCht In oSh.ChartObjects          oCht.Chart

2017-01-10 Chart appearance.:

The macro saves in whatever Excel thinks is the current folder. If you post the macro here I can adjust so that it saves to the same folder as the workbook is in. Basically, you would need to add this

2017-01-07 Chart appearance.:

Another way is to use a small macro:    Sub SaveCharts()      Dim oSh As Worksheet      Dim oCht As ChartObject      For Each oSh In Worksheets          For Each oCht In oSh.ChartObjects          oCht

2017-01-06 Chart appearance.:

Have you seen this article, perhaps it helps you?    https://www.tekrevue.com/tip/export-excel-charts/

2016-11-05 Number of different names:

Hi Richard,    There are different ways to do that.    1. A pivot table    Simply create a blank pivot table using insert, pivot table and click on the name field to add it to the row area.      2. An

 

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2017 About.com. All rights reserved.