Chart Pattern Fills

MSDN Blog Postings » Chart Pattern Fills

MSDN Blog Postings » Chart Pattern Fills — Sat, 17 Nov 2007 04:21:34 GMT

PingBack from http://msdnrss.thecoderblogs.com/2007/11/16/chart-pattern-fills/

Chart Pattern Fills

Windows Vista News — Sat, 17 Nov 2007 05:45:02 GMT

Did you see the post at blogs.msdn.com

re: Chart Pattern Fills

Francis — Sun, 18 Nov 2007 10:50:25 GMT

In addition to B&W printing, I have used patterns in a couple of cases in color charts:

- to indicate association (e.g., where slices in a pie are related in some way, kind of like the intersection in a Venn diagram, e.g. in a chart of fruit sales, all citrus fruit has orange hatching over individual background colors)

- to indicate a uncertainty or options (e.g., in a stacked column chart, where series 1 is filled solid up to a certain value, and series 2 is shaded to indicate possible increase from series 1 values, e.g. returns under optimal conditions)

re: Chart Pattern Fills

Ute Simon — Sun, 18 Nov 2007 13:38:45 GMT

I wish this option were available for PowerPoint 2007, too. Though PPT-charts are now based on Excel, there seems to be no way to apply pattern fills to them. :-(

Aside from printing in b&w, patterns are a great help for colorblind people to help them distinguish the items.

re: Chart Pattern Fills

Yuvraj — Mon, 19 Nov 2007 10:56:37 GMT

After saving the file as an add-in, can i apply rights to it? when i open the xla file the permission icon for assigning rights is grayed out.

Is password protection the only way to protect an add-in file?

re: Chart Pattern Fills

gkoehler — Wed, 21 Nov 2007 21:32:19 GMT

I hope patterns are restored as a built-in option from Ribbon with Office SP1. Should not have to spend time creating custom solution to get something I already had in previous version.

re: Chart Pattern Fills

kokkit — Thu, 22 Nov 2007 06:57:04 GMT

Posting in this blog is rather inconvenient. I apologize for spaming chart pattern fills with a theme color issue.

I was wondering if anybody realize, in Excel 2007, theme colors 0 to 3 do not match. Theme index of 0 in styles.xml is mapped to color 1 and theme index of 1 is mapped to color 0 in theme1.xml. Same thing happens to color 2 and 3.

This is contradicting to the spec (OOXML part 3, page 147). Perhaps, the engineer misused this erratic mapping that could be resulted from the clrSchemeMapping order in Word?

Thanks

re: Chart Pattern Fills

Tue, 27 Nov 2007 17:55:11 GMT

Kokkit:

Yes! I noticed that too. I had to stick in a little swap just for those four colours and only for Excel. I'm thinking there is a map, like the explicit one in PowerPoint, but instead of being stored in the file it is internal to Excel since it is constant (or maybe they just wanted to keep us on our toes?). Talking about constant things, try modifying fill style 0 in styles.xml by hand...

Talking about themes and colours, can anyone figure out how to apply tint in charts properly? The ECMA documentation indicates some sort of linear formula but that's not what I'm seeing. I've tried asking the OfficeArt guys but their blog is dead. I've also asked this at the developper Forum but no one's replied there either.

http://openxmldeveloper.org/forums/thread/1627.aspx

Any hints would be greatly appreciated. The magic formula itself would earn my eternal gratitude.

re: Chart Pattern Fills

Stephane Rodriguez — Sat, 01 Dec 2007 16:20:04 GMT

"I was wondering if anybody realize, in Excel 2007, theme colors 0 to 3 do not match. Theme index of 0 in styles.xml is mapped to color 1 and theme index of 1 is mapped to color 0 in theme1.xml. Same thing happens to color 2 and 3."

The first two colors are indeed swapped. It's a bug in Excel 2007. To fix this without killing existing Excel 2007 files, they will have to introduce a new disambiguation attribute, which in turn will make developers' lives harder (since they will have to implement both cases instead of just grabbing the color by index).

re: Chart Pattern Fills

Mbajiuka Uchechukwu — Wed, 12 Dec 2007 18:46:27 GMT

I am school lecturer needs to know all about the tutorial on microsoft excel chart.

http://www.middle-empire.com

Middle Empire — Fri, 14 Dec 2007 06:59:09 GMT

Very good tips!

Middle-Empire

http://www.middle-empire.com