ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Adding new graph markers (https://www.excelbanter.com/charts-charting-excel/234688-adding-new-graph-markers.html)

Miguel M[_2_]

Adding new graph markers
 
I am running out of markers in some of my ghraphs and I was wondering whether
one can import new markers in Excel 2007, e.g. inverted or side looking
triangles, pentagones, etc.

Andy Pope

Adding new graph markers
 
Hi,

Here is some information on custom markers.
http://peltiertech.com/Excel/ChartsH...omMarkers.html

But if you have that many markers you might need to consider your choice of
chart as it will get difficult to see the information in the chart.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Miguel M" wrote in message
...
I am running out of markers in some of my ghraphs and I was wondering
whether
one can import new markers in Excel 2007, e.g. inverted or side looking
triangles, pentagones, etc.



Miguel M[_2_]

Adding new graph markers
 
Cheers Andy

It works!

I was thinking more of Excel import of new markers but this works too. The
only drawback is that once pasted you cannot edit the size/colour from the
graph, you have to do it outside and paste them back again.

Many thanks
Miguel

Andy Pope

Adding new graph markers
 
True.
Excel does not allow for new marker types. You only control is the fore/back
colour in conjunction with the built-in shapes.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Miguel M" wrote in message
...
Cheers Andy

It works!

I was thinking more of Excel import of new markers but this works too. The
only drawback is that once pasted you cannot edit the size/colour from the
graph, you have to do it outside and paste them back again.

Many thanks
Miguel




All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com