Clock in Scatter Chart

Hello Everybody,

Clock (without using Timer) created in Scatter chart (Excel Chart), yeah its true. I got inspired from the work “Fireworks in Scatter chart” done by Excel MVP “Andy Pope” (Chart Genius).

I have used the same logic to create clock in scatter chart, that I was used in “JAVA” language Clock in Java Applet”. Here I have used sine and cosine function to draw the outline for the chart, which is based on radius value in the sheet “Scatter Clock” (in the Attached file).

Please download the file “Download Scatter Chart” here.
Based on X and Y series, i have acheived the thing here.

If any queries, please free to mail me or add comment to this post.

Thanks & Regards,
Karthick

My First VBA tips

Hello VBA developer,



From now onwards, am going to post topics (tips) related to VBA (Access & Excel).

Before that, am greatfully thankful to my Boss Naresh Nichani (Access MVP) and Virtual Boss Brian Reilly(Power Point MVP), who are giving more oppotunities to learn, develope and design the stuffs in VBA (Excel and Access).



Here is my first Tip in Excel.

Custom Formats

Without using the conditional formatting, we can customize the format (Font Color), based on cell value (applicable to number)



[Red]"Export";[Blue]"Import";[Black]"Balance"



First Copy the above line (in brown color) and then right click any one of the cell in excel sheet (where do u need to format),

Select "Format Cells" --> "Number" tab --> Click "Custom" --> paste it in "Type " text box.

For Eg:

Lets assume, you assigned the above custom format in cell "A2",

Then if Cell value is + ve then Export text will be displayed
is - ve then Import text will be displayed
is 0 then Balance text will be displayed

Hope you understand that, If any queries or doubts, please let me know, by commenting this post.

Thanks & Regards,
Karthick