Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 10th 06, 02:26 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 43
Default User-defined charts

Hello,

I'm trying to build some user defined charts for several users to
maintain consistent formatting etc. I know how to make the charts,
saving them and most settings but there is one issue I haven't solved
yet.

The user defined charts will be used on lots of different datatypes.
For exampel, one of the charts will have 2 dataseries but another will
have 10. They should still have the same type of formatting in all
series. Lets say they want a Line chart and the the lines should be of
a spesific thickness (thicker than default). How can I make sure that
all lines will have this thickness, no matter how many dataseries
there are? Do I have to create a user defined chart with a maximum
number of dataseries and format all series to my specifications?

--
Fredrik E. Nilsen

  #2   Report Post  
Old December 10th 06, 04:09 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default User-defined charts

Do I have to create a user defined chart with a maximum
number of dataseries and format all series to my specifications?


That's right.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Fredrik E. Nilsen" wrote in message
...
Hello,

I'm trying to build some user defined charts for several users to
maintain consistent formatting etc. I know how to make the charts,
saving them and most settings but there is one issue I haven't solved
yet.

The user defined charts will be used on lots of different datatypes.
For exampel, one of the charts will have 2 dataseries but another will
have 10. They should still have the same type of formatting in all
series. Lets say they want a Line chart and the the lines should be of
a spesific thickness (thicker than default). How can I make sure that
all lines will have this thickness, no matter how many dataseries
there are? Do I have to create a user defined chart with a maximum
number of dataseries and format all series to my specifications?

--
Fredrik E. Nilsen



  #3   Report Post  
Old December 10th 06, 04:48 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 43
Default User-defined charts

On Sat, 9 Dec 2006 22:09:05 -0500, "Jon Peltier"
wrote:

Do I have to create a user defined chart with a maximum
number of dataseries and format all series to my specifications?


That's right.


Thanks for your quick reply. A couple of more questions then: What is
the maximum number of dataseries in a chart? And is there a way to
achive consistant formatting through VBA?

--
Fredrik E. Nilsen
  #4   Report Post  
Old December 10th 06, 04:00 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default User-defined charts

You can have up to 255 series in a chart, which should be more than enough
for any legible chart.

In vba you can apply formats to a chart, so this is a matter of setting up
the code to apply the desired formats to the appropriate series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Fredrik E. Nilsen" wrote in message
...
On Sat, 9 Dec 2006 22:09:05 -0500, "Jon Peltier"
wrote:

Do I have to create a user defined chart with a maximum
number of dataseries and format all series to my specifications?


That's right.


Thanks for your quick reply. A couple of more questions then: What is
the maximum number of dataseries in a chart? And is there a way to
achive consistant formatting through VBA?

--
Fredrik E. Nilsen



  #5   Report Post  
Old December 10th 06, 04:12 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 43
Default User-defined charts

On Sun, 10 Dec 2006 10:00:45 -0500, "Jon Peltier"
wrote:

You can have up to 255 series in a chart, which should be more than enough
for any legible chart.

In vba you can apply formats to a chart, so this is a matter of setting up
the code to apply the desired formats to the appropriate series.


Thanks again! I have tried google for more information about how Excel
handles this but I haven't found anything that goes in the depth of
it. Do you have any pointers? Sites, books etc.

It seems to me there should be an option to set these settings once
and for all. I have customers making reports with 30-50 different
charts every day and they spend a lot of time tweaking the formatting.
Is VB really the only way to go? Any add-ins you know of? Or do people
use other tools for this sort of work?

--
Fredrik E. Nilsen


  #7   Report Post  
Old December 10th 06, 05:12 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 43
Default User-defined charts

On Sun, 10 Dec 2006 09:48:38 -0600, "Don Guillett"
wrote:

Jon is perhaps the foremost charting authority for excel.

Jon Peltier's Excel Charts


Yes, so I've noticed.

--
Fredrik E. Nilsen
  #8   Report Post  
Old December 10th 06, 05:57 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default User-defined charts

I meant to give you the url to his web site
http://peltiertech.com/Excel/Charts/index.html
--
Don Guillett
SalesAid Software

"Fredrik E. Nilsen" wrote in message
...
On Sun, 10 Dec 2006 09:48:38 -0600, "Don Guillett"
wrote:

Jon is perhaps the foremost charting authority for excel.

Jon Peltier's Excel Charts


Yes, so I've noticed.

--
Fredrik E. Nilsen



  #9   Report Post  
Old December 11th 06, 06:39 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 43
Default User-defined charts

On Sun, 10 Dec 2006 10:57:46 -0600, "Don Guillett"
wrote:

I meant to give you the url to his web site
http://peltiertech.com/Excel/Charts/index.html


Yes, I know about his website and I've been through it. I'm seeking
even more in-depth information.

--
Fredrik E. Nilsen
  #10   Report Post  
Old December 11th 06, 01:02 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default User-defined charts

What VBA does is applies the tweaking automatically. You need to come up
with a template or a set of tweaks that make people happy enough with the
chart. I don't know what you mean by set the settings once and for all,
unless you want a more totally VBA approach that dumps the data into an
Excel template and plots it in a protected chart. Otherwise, human nature
dictates that people are going to tweak.

If you decide to use VBA, you could start with some recorded macros, then
examine the code and remove duplicate items and stray mouse actions.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Fredrik E. Nilsen" wrote in message
news
On Sun, 10 Dec 2006 10:00:45 -0500, "Jon Peltier"
wrote:

You can have up to 255 series in a chart, which should be more than enough
for any legible chart.

In vba you can apply formats to a chart, so this is a matter of setting up
the code to apply the desired formats to the appropriate series.


Thanks again! I have tried google for more information about how Excel
handles this but I haven't found anything that goes in the depth of
it. Do you have any pointers? Sites, books etc.

It seems to me there should be an option to set these settings once
and for all. I have customers making reports with 30-50 different
charts every day and they spend a lot of time tweaking the formatting.
Is VB really the only way to go? Any add-ins you know of? Or do people
use other tools for this sort of work?

--
Fredrik E. Nilsen





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with user defined function panjo Excel Discussion (Misc queries) 3 June 16th 06 11:18 AM
User defined functions without using VBA. [email protected] Excel Discussion (Misc queries) 0 June 13th 06 05:50 PM
user defined function help Floyd Steele Excel Worksheet Functions 1 February 2nd 06 11:47 PM
I have had difficulty in creating user defined functions in Excel MichaelG Excel Worksheet Functions 3 July 13th 05 11:59 AM
User defined charts- font size too small Bill B Charts and Charting in Excel 1 December 30th 04 07:23 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017