User Function for inserting chart

[Ninad Pradhan]

Hi,

I need to insert a chart with X-axis having Issue Rating as "High", "Medium", "Low". The Y-axis is the numbers.

Since all auditors have their own formatting, I want to standardize this through this function.

Graph type: Column
Coloring: "High" data point - Red
"Medium" data point - Gold
"Low" data point - Sea Green
Title: Number of Issues by Rating

TIA.

Ninad.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Client Side Script to Export To Excel 2007
http://www.eggheadcafe.com/tutorial...3-3bc58854b589/client-side-script-to-exp.aspx

 

[Jonathan West]

Hi,

I need to insert a chart with X-axis having Issue Rating as "High",
"Medium", "Low". The Y-axis is the numbers.

Since all auditors have their own formatting, I want to standardize this
through this function.

Graph type: Column
Coloring: "High" data point - Red
"Medium" data point - Gold
"Low" data point - Sea Green
Title: Number of Issues by Rating

TIA.

Ninad.

Insert an ordinary chart.

Format it the way you want it.

Select it, and then save it into your template as an AutoText entry.

Distribute your template to your colleagues.

Then, whenever they need a chart of that type, they can insert the AutoText
entry, and then open the chart to type or paste their data in.

 

[Ninad Pradhan]

Will try it out. Thanks.



Jonathan West wrote:

Insert an ordinary chart.Format it the way you want it.
28-Jan-10

Insert an ordinary chart

Format it the way you want it

Select it, and then save it into your template as an AutoText entry

Distribute your template to your colleagues

Then, whenever they need a chart of that type, they can insert the AutoTex
entry, and then open the chart to type or paste their data in

-
Regard
Jonathan West

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASPNET_MERGE and Web Deployment Projects Arrive!
http://www.eggheadcafe.com/tutorial...d0-128b8e8c586e/aspnetmerge-and-web-depl.aspx