I am working with the Ganntt chart and horizontal bar charts but can't seem to figure out a way to force the X-Axis to behave properly.In Excel 2007, I am trying to get the X-Axis to show major units of Months. Here's the (reduced) code :Code:Dim appExcel As Object ' Excel ApplicationDim chtPareto As Object ' ChartSet appExcel = CreateObject("Excel.Application")Set chtPareto = appExcel.Charts.AddWith chtPareto' Primary category axis[code]....The category (x) axis title should be horizontal, whereas the value (y) axis title should be rotated. 1. I have arranged the rank column in cells B38:L38 as they would appear. Even if I format the axis to Dates, they appear as 1.00.1900, 1.02.1901, etc. Is Excel 2010 any easier for this? Conditional Formatting Percentage Axis For Thermometer Chart? See screenshot: 2. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. Is there any way I could get rid of the sign? but there is no option for log charts. Primary i want the shade of blue below. Stepping through the code, when I .SetElement for the category axis title, it appears horizontal as planned. See screenshot: 2. However, as soon as I .SetElement for the rotated value axis title, the category axis title also rotates. How to move minus sign from right to left/back to front in Excel? Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Why the recorded code doesn't work? If you have Kutools for Excel – a handy tool, you can quickly convert negative numbers to positive numbers with the Change Sign of Values utility. Any advice on how to do this? I would like to make a graph with an x, y and z axis. I have a numerical X-axis with values such as 0,1,5,8,14, etc. Excel 2007 :: Dates By Month On X-Axis In Horizontal Stacked Bar Chart? I currently have a thermometer chart in Excel 2013 that I set up with percentages along the Y-Axis. I got a set of data which is only 2 colums collecting data problems. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. All I want to do is color the numbers on both the primary and secondary axis. a_Y-Axis auto scale.zipHow to autoscale chart using VBA, so i can maximize the viewable area without using the default format axis on chart each time i paste new data to the table. I have some numeric data that has to be put on a log chart. In the Format Cells dialog, under Number tab, select Number from the Category list, and the go to the right section and type 0 into the Decimal place textbox, and select one type of Negative numbers as you need. This tutorial assumes that you have a cell, or cells, that automatically adds a percentage symbol behind a number after you type it in. The bar chart would be a single bar that represents the percentage complete (33%) with the chart maximum range being 100% which would represent the number 38.Ive included a mock up example of what the data and chart would look like. There is an easy formula can help you get the absolute value of the numbers with leading minus. so i converted my data to log and then drew a chart but i am unable to edit the axis intervals and starting axis value. I want to draw a chart in Excel, in X axis Dates and in Y axis some other data. How to Remove Percentage Signs From Excel. Selection.Replace What:="~~", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=FalseSelection.Replace What:="^", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=FalseSelection.Replace What:="~*", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False. how to incorporate another category and value axis to my existing chart. The values in Column A are all dates in this format: mm.dd.yyyy. So when I set the vertical axis to percantage format, it does display it as a percentage but with the "%" sign. Row 2 has the event numbers titles 1 to 18 (18 events in a year). Code: Sub Macro2() ActiveSheet.Shapes.addChart.Select ActiveChart.ChartType = xlXYScatter ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).Name = "=""Rate of Productivity""" ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!$A$2:$A$4" ActiveChart.SeriesCollection(1).Values = "='Sheet1'!$E$2:$E$4"End Sub, i want 0 values to start at x and y axis.basically i want time in secs on x axis starting a 0 upto 4.4 secs, X Axis In Pivot Chart Shows Decimal Than Percentage. Here is the code (also, I would like a VBA solution but if this is with excel's chart tools, so be it). In the Change Sign of Values dialog, check Change all negative values to positive option, see screenshot: 3. After free installing Kutools for Excel, please do as below: 1. Here are some tricks I can introduce to help you. The second method would be to convert the percent value to a string, remove the percent symbol and treat the remainder as a value. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. Click Ok. And now you can see all the negative numbers have been converted to positive. The thermometers are showing spending based on a budgeted number. What I need is a chart that shows me the market size in column graph, my market share in line graph and I want the percentages to be showing also. How can I plot a 3-axis graph? Excel 2010 :: Create Percentage Bar Chart? Is there any way I could get rid of the sign? Removing Percentage Sign On Excel Chart Axis? After free installing Kutools for Excel, please do as below: 1. Draw Log Chart Or Edit Axis Intervals And Starting Axis Value. Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day. Secondary I want the shade of green below. =A1*100. Is there a suitable way to do this? These steps are very similar for other versions of Excel, but may vary slightly. May 21, 2014. Show Missing Values In Pivot Chart (line Chart) Axis? Excel 2010.sub color_axis() ActiveChart.Axes(xlValue).TickLabels.Font.Color = RGB(38, 40, 118) ActiveChart.Axes(xlSecondary).TickLabels.Font.Color = RGB(0, 153, 0)end sub, Im looking to create a bar chart in Excel 2010 where the totalnumber of widgets is 33 and the number produced so far is 11. Excel 2007 :: Primary Category Axis Title Rotates With Rotated Value Axis Titles, Basic Chart: Set A Chart Up With The Time Been On The X - Axis. Open and create multiple documents in new tabs of the same window, rather than in new windows. I have another set of Y values that correspond to the X values. However, in my chart options I can only change the Y-Axis to be Date/Monthly.Changing my data layout (from the below) to be a vertical format produces the same problem, just in the other direction.My data looks as follows:SystemBlockerProductionMigrataionRetiredSys11/1/2012780Sys21/1/20124006090Sys32/1/20133051The Blocker column is formatted as "No Fill" in order to cover a portion of the time-scale.My X-Axis displays as random dates throughout the period and all of my data displays properly in terms of the scale on the grid.What is NOT working is that the dates shown on the X-Axis really need to be based on a Monthly scale instead of the randomly selected dates Excel is using.20120823.xlsxI can't seem to find the right combination of options to make that happen or force a scale on the X-Axis. I have a bar graph in excel 2010 and the vertical access is stuck in the middle of the graph. Select a blank cell next to the numbers, for instance, B1, and type this formula =ABS(A1) (A1 is the cell you want to remove the leading minus sign), and then drag autofill handle down to fill the cells needed this formula.