Is it possible to rotate a chart in excel

From the guest list to the Gannt chart - i did a few tutorials on dynamic gantt charts using conditional formatting but cannot get them to work when based on data on a different worksheet. Finaly is there a way to check for availabilty on any given date? Best Regards, Jamie P. I have been using Excel XP to make a text chart for several months.

Some of my text entries are rather lengthy. The past two weeks these lengthy entries are showing up as pound signs when I click off the cell. I know the text will fit in the cell, and the problem isn't solved by making the cell bigger or using a little bit less text. I have the cells formatted as "text" and "wrap to fit". I have printed the pages and the printed version also has pound signs.

I just want my text to show up! Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet. I am running Excel for Mac. I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet.

The Pivot Table data is fine, but I want it to display alongside the source data. I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Appreciate any help, let me know if you have any further questions. In my pivot table I have a lot of cells without any data. Finding X-axis Intercept - Excel.

So I've got some data, which has the approximate form of a sine function. I want to find all the x-axis intercepts. I tried using the intercept function and swapping around the y values for the x values, but it only returns 1 value so I'd guess it uses a linear regression to estimate a single line through the axis.

Basically I want to identify the two values where it switches from positive to negative and also indentify the values where it goes negative to positive, I can then fit a straight line between them to find a better approximation of the intercept though it might not be necessary. Can anyone suggest how I'd find these value or the x-intercept.

Any help would be greatly appreciated. I have a graph with various information in it. One is a line graph that tracks hours used in that department per month. The problem is that when it gets to the last month, and there is not yet data for future months, the line goes down to Zero leavin this big diagonal line that makes the data look funny.

I need this line to stop on the last month there is data for. I do not manually enter the data, it is a formula that I do not wish to delete. I know I can manually move the data that the line is pulling to make it stop on the last month, but I have a graph for 36 different departments and that's a pain to have to manually adjust 36 graphs each month. Is there a way to tell the line to stop if there is no data?

Dear Sir, If any one could give me a solution for this its will be a great help for me. I am working in a bank and on every day we receive Month to date data of Loans and advances made by every branch with Region wise total and manager wise total.

With Sum of loan and count of loan. In our MIS format the in A coulum branches are sorted and listed in a sequence with sub total Region. I have data where if if do the pivot and change the data the out put should be displayed accordingly in the MIS format. Unfortunately, every time I do it I get the result NA.

If so, is there any special syntax I need to use? Corporate edict. I have a worksheet that is locked and protected now, except for cells in a certain collumn. I have named the cells in that column "MS96A". If a user enters a date in a cell or range of cells anywhere in the column, the changed cells also need to be locked and protected Once they enter a date, it is not allowed EVER to be changed again. You must log in or register to reply here. Similar threads L.

Question Expert Graph needed. LebD Oct 11, Excel Questions. Replies 3 Views Oct 11, LebD. Question Can I add a horizontal average line to a chart without calculating it in cells? RockandGrohl Aug 13, Excel Questions. Replies 1 Views Aug 13, GraH. Question Line not visible on chart. QDavis Apr 21, Excel Questions. Replies 7 Views 2K. Apr 22, RoryA. Aug 24, Yongle. Forum statistics Threads 1,, Messages 5,, Members , Latest member curezeal.

We've detected that you are using an adblocker. We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel. Rotating the Excel chart Change the spreadsheet orientation Selecting a paper size Rotating the Excel chart Excel charts help to make sense of your data. Click on the chart to see Chart Tools on the Ribbon.

Select the Format tab. Click the Format Selection button to see the Format Axis window. On the Format Axis window tick the Values in reverse order checkbox. Change the spreadsheet orientation Some worksheets are wider than they are tall, so you may find that printouts look better if you switch the orientation from the portrait mode to the landscape one.