charts: 1. link to a cell in chart titles, 2. custom chart template

[mnjiodek]

hello,

1.
how can i make a link to a cell in chart title, category axis & value axis?
i'd like to know how to make a title like eg below:

'Average revenues
[=B2], [=B3]' <- in line below (smaller font size than in line above)

2.
how can i make a my own chart (custom type) by making a own template (how to make a template, and how to implement it to excel
custom types charts)
i am interested in making types similar denkin diagram (similar to radar type) or leontief branch flow matrix (similar to x-y plot
with columns and rows with second x axis and second y axis)
is there any chart/ plot/ chart template editor or helpful instruction (in i-net) covering this topic?


Big thanks for help.

Regards.

 

[Jon Peltier]

1. You can link a title to the contents of a cell, but you can't use a
formula that refers to more than one cell or includes text. Use a
formula in a cell to build the label you want to see, then select the
axis title or chart title, press the Equals key, and select the cell
with the mouse.

If you need different font sizes, you will have to make two different
text items. One can be the title, the other must be a text box. Making a
textbox linked to a cell is easy. Select the chart, press the Equals
key, and select the cell with the mouse.

2. First design a chart. Then select the chart and choose Chart Type
from the Chart menu. Click on the Custom Types tab, then check the User
Defined option. Click Add, then enter a name and description for the
chart. Then press okay until you are out. Next time you make or format a
chart, you will be able to select your custom chart type for the new chart.

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

 

[mnjiodek]

G³upia wrotka dla Jon Peltier:

If you need different font sizes, you will have to make two different
text items. One can be the title, the other must be a text box. Making a
textbox linked to a cell is easy. Select the chart, press the Equals
key, and select the cell with the mouse.

now it is easy...

2. First design a chart. Then select the chart and choose Chart Type
from the Chart menu. Click on the Custom Types tab, then check the User
Defined option. Click Add, then enter a name and description for the
chart. Then press okay until you are out. Next time you make or format a
chart, you will be able to select your custom chart type for the new chart.

But i'd like to design completely different (from other chart types) chart - a chart that do not bases on available charts...
Is there possibility to make a template and implement it or use any chart editor or anything to create such a chart?

 

[Jon Peltier]

G³upia wrotka dla Jon Peltier:




now it is easy...




But i'd like to design completely different (from other chart types) chart - a chart that do not bases on available charts...
Is there possibility to make a template and implement it or use any chart editor or anything to create such a chart?

There's always the possibility. But you need some way to get information
from a sheet into graphical form. Excel's charts are a pretty handy way
to do this.

What's the nature of your specialized chart? What makes it unsuitable
for adaptation of an Excel chart? There are many things you can do with
charts that are not apparent at first glance. To see a few examples,
browse around my web site for a few minutes.

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

 

[mnjiodek]

G³upia wrotka dla Jon Peltier:

There's always the possibility. But you need some way to get information
from a sheet into graphical form. Excel's charts are a pretty handy way
to do this.

i.e.

denkin diagram presenting correlation between many variables
this chart is similar to tree
imagine n time series of revenues and time serie of GDP [1]
then at radar chart i present value of n correlation between revenues and GDP
(but i'd like each value show as line from centre to velue)
i created such a chart with VBA code that modyfies colour and thickness of those lines
[in case of minus value of correlation i present module of this value with cold coloured line]

but i'd like to expand this chart. [2]
First i find values of correlations between revenues (each with each)
From each point representing value of correlation i want guide lines representing correlations between a particulary time serie of
revenue and 3 time series that are most correlated and 3 that are less correlated

it is also similar to fractal structure
if you read post in curier new look at an ascii below

\ | /
\|/_.-
+'--
\ | /
._\|/_.
| '+' <-- correlation [2] between n time series
| / | (only choosen 3 max and 3 min values)
| / \ | / |/_
| / \|/_.-
| / _..+'---
main |/ _..--'' /|\'-.
correlation ---> +' / | \
[1] n values

is it clear? sorry i have same troubles with describing in english ;/

i think it is manageable with VBA and simple x-y chart (each piont must have own x, y parmeters and position in data range
depending on value of correlation)

i.e. type in following data:
x: -3 4 3 4 5 4 6 4 7 4 6 4 5 4 3
y: 3 3 1 3 1 3 2 3 3 3 4 3 5 3 5

and you will see example of second step with using only XY chart

but i find this way to arduous... ;/

What's the nature of your specialized chart? What makes it unsuitable
for adaptation of an Excel chart? There are many things you can do with
charts that are not apparent at first glance. To see a few examples,
browse around my web site for a few minutes.

i visited your page long time age - i found some useful files and tips
thanks

regards

 

[Jon Peltier]

You are obviously further outside the box than most. Take a look at
Fernando Cinquegrani's web site:

http://www.prodomosua.it/ppage02.html

He has done some very intriguing things, constructing graphics with VBA
that go beyond regular Excel charts. There may be things there that
approximate your intent.

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

G³upia wrotka dla Jon Peltier:

There's always the possibility. But you need some way to get information
from a sheet into graphical form. Excel's charts are a pretty handy way
to do this.

i.e.

denkin diagram presenting correlation between many variables
this chart is similar to tree
imagine n time series of revenues and time serie of GDP [1]
then at radar chart i present value of n correlation between revenues and GDP
(but i'd like each value show as line from centre to velue)
i created such a chart with VBA code that modyfies colour and thickness of those lines
[in case of minus value of correlation i present module of this value with cold coloured line]

but i'd like to expand this chart. [2]
First i find values of correlations between revenues (each with each)
From each point representing value of correlation i want guide lines representing correlations between a particulary time serie of
revenue and 3 time series that are most correlated and 3 that are less correlated

it is also similar to fractal structure
if you read post in curier new look at an ascii below

\ | /
\|/_.-
+'--
\ | /
._\|/_.
| '+' <-- correlation [2] between n time series
| / | (only choosen 3 max and 3 min values)
| / \ | / |/_
| / \|/_.-
| / _..+'---
main |/ _..--'' /|\'-.
correlation ---> +' / | \
[1] n values

is it clear? sorry i have same troubles with describing in english ;/

i think it is manageable with VBA and simple x-y chart (each piont must have own x, y parmeters and position in data range
depending on value of correlation)

i.e. type in following data:
x: -3 4 3 4 5 4 6 4 7 4 6 4 5 4 3
y: 3 3 1 3 1 3 2 3 3 3 4 3 5 3 5

and you will see example of second step with using only XY chart

but i find this way to arduous... ;/

What's the nature of your specialized chart? What makes it unsuitable
for adaptation of an Excel chart? There are many things you can do with
charts that are not apparent at first glance. To see a few examples,
browse around my web site for a few minutes.

i visited your page long time age - i found some useful files and tips
thanks

regards

 

[mnjiodek]

G³upia wrotka dla Jon Peltier:

You are obviously further outside the box than most. Take a look at
Fernando Cinquegrani's web site:

http://www.prodomosua.it/ppage02.html

He has done some very intriguing things, constructing graphics with VBA
that go beyond regular Excel charts. There may be things there that
approximate your intent.

ooo! - you are great thank you