Showing posts with label bar. Show all posts
Showing posts with label bar. Show all posts
Wednesday, March 16, 2016
How to Remove Navigation Bar from Blogger Blog
By default your blogger blog will have a generic navigation bar like other blogger sites. But it doesnt look professional if your site has common navigation bar at the top of it. And this is actually not very essential for your site. So you can remove it without any hesitation. Of course you can get it back any time if you change your mind.
Customize Your Blog
To be honest the default navigation bar of blogger has few advantages. It will allow your visitor to:
- Search your site
- Share your site on Google +
And it also allow you to:
- Sign in to your site or sing out from your site
- Access your blogger dashboard
But professional bloggers neither like to navigate from here nor let the visitors to use this. They like to use custom sharing and navigation options within the blog area. So, if you would like to give a professional look to your blogger blog then you can remove it from your site. Just do the following:
- Make sure youre logged in to your blogger account.
- Go to the dashboard and hit on the Layout.
- Find the Navbar widget and click on Edit as shown in the image below.
- There are 6 types of navigation bar. And at the end there is Off option.
- Select Off and Save it. Thats it. Now visit your site.
You can get it back anytime. To turn on this bar follow all the above steps. Just choose any of the 6 type of bars in the step 5.
Add Your Own Favicon in Blogger
Stay with Marks PC Solution to get more interesting IT topics!
Friday, February 12, 2016
Creating Column Bar Pie Chart in MS Excel With Sheet
Hello Dudes! Hopefully youre alright and also hope youre enjoying my posts. After a long time, Ive come with MS Excel Tips. Couple of Months ago, I shared an Excel Sheet with you that includes - Salary Sheet, Result Sheet, Electric Bill etc. Today Ive come with another sheet which will help you to learn how to create Column, Bar and Pie Chart in MS Excel.
Actually I was planning to share this tips with you for a long time. But I couldnt understand how to start and what to write. Finally, Ive decided to share a sheet with you as example. And I will also try to clarify how to create charts in MS Excel.
Applies to:
- Office 2007
- Office 2010
- Office 2013
But Ive used Office 2010. So there might be some changes in other versions.
Download Column, Bar & Pie Chart Sheet
For your convenience, you can download the above file and have a look before we start. Its just 22 KB! Remember, it is an .xlsx file and can only be opened with Office 2007 or above. Three charts are in three sheets. You will get the names at the bottom of the worksheet.
Okay lets begin. I am using Office 2010.
Column Chart:
Column Chart is a widely used chart which is normally used to show Profit, Growth Rate etc. It is shown as vertical lines. In my example sheet, I showed the pageviews of my site for last five months. To create a column chart, follow the steps below:
- Run MS Excel.
- Input your data (Maybe you can enter particular in one column and values in other columns). In my example, I showed only a single column value. You can enter multiple columns. Maybe you can show the pageviews of three years while I showed only one year.
- Now select your input data (in my example, I selected only data - June to 120000) to avoid the column header to be appeared in the chart.
- Go to the Insert Tab > Find the Chart Section > Choose Column (Ive used the first one).
- Now you will see a Column Chart in your book.
Bar Chart:
This is almost similar to Column Chart but gives you a different flavour. It presents data horizontally. Creating a Bar Chart is almost similar to that of Column. After inputting the data, you have to go to the Charts and then choose Bar Chart.
Pie Chart:
The best example of the use of Pie Chart is the representation of Budget. Without Pie Chart, representation of budget cant be imagined. It is notmally used when something is divided into parts. For example, in a budget, we can see what percentage of money will be spent in a particular sector.
Such as for Education - 20%, for Defense - 30%, for Industry - 15%, for Power - 20% etc. Only Pie Chart can show this properly.
To create a Pie Chart (take help of my example sheet), you have to enter the category in one column, and then enter the values in another column. Then select the input data, go to the charts, choose Pie Chart. Thats it.
Customization of Charts:
Creating a chart is not very difficult. But arranging it properly could be a boring task if you dont know how to do it. Im gonna discuss about customizing the charts in brief:
- After creating any chart, if you click on it, you will get three new tabs - Design, Layout and Format.
- From Design Tab, you can change your chart design - Chart Style and Layout.
- In Layout Tab, you will find Chart Title, Legend Position, Data Label etc.
- Format Tab will allow you to perform all kinds of formatting tasks including text color, line color, line style, font style, shape effects etc.
Of course you can use your mouse to choose a particular part of the chart. Then you can change that part. To select a segment of your chart, click on it and then click again (not double click). If you wanna move any part of your chart, hit on it and move it when you get the moving pointer.
Stay with Marks PC Solution to get more interesting IT topics!
Subscribe to:
Posts (Atom)
