X Axis In Pivot Chart Shows Decimal Than Percentage

Sep 15, 2014

I had created a pivot table and pivot chart for the data, the pivot table shows the row label's as percentages which is correct, but it when comes to the pivot chart it shows it as decimal, for example a 10% shows 0.1, I tried of formatting the x axis and choose percentages but it doesn't want to change.

View 6 Replies


Conditional Formatting Percentage Axis For Thermometer Chart?

Jun 11, 2014

I currently have a thermometer chart in Excel 2013 that I set up with percentages along the Y-Axis. The thermometers are showing spending based on a budgeted number. Currently, the project is over-budget so I have adjusted the thermometer scale to go far beyond 100%.

I would like to have the percentages past 100% show in red along the lefthand side.

View 2 Replies View Related

Removing Percentage Sign On Excel Chart Axis?

May 21, 2014

I realize all the numeric data was originally not in percentage format (a simple division without being multiplied by 100). So when I set the vertical axis to percantage format, it does display it as a percentage but with the "%" sign. Is there any way I could get rid of the sign? It's not necessary as the axis has already been titled accordingly. I'd hate to redo all calculations, multiply by 100 and then create new charts only to get rid of the sign...

View 1 Replies View Related

Show Missing Values In Pivot Chart (line Chart) Axis?

Apr 18, 2013

How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. 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. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. 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. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.

View 1 Replies View Related

Change X-axis Labels On Pivot Chart?

May 15, 2014

I have a data set where a number of pieces of technology are listed in rows. For each piece of technology it can relate to a "Network" or a "Terminal" and the columns are yes/no as follows:

Tech Network? Terminal?

Tech 1 Yes No
Tech 2 Yes Yes
Tech 3 No No
Tech 4 No Yes

When I plot this on a pivot chart, I get the attached chart, where the x-axis relate to the hierarchies, i.e. Yes/Yes, Yes/No, No/Yes or No/No. As you can imagine, this is not very useful for the viewer as it's not clear what the yeses and nos refer to. It would be much better if I could rename the axis labels: "both"; "network only"; "terminal only"; or "neither".

Is this possible? And is there a solution that doesn't require me to change the source data? I'm happy to use a power pivot if that would make things easier.

View 1 Replies View Related

Pivot Table Chart - How To Swap X And Y Axis

Dec 4, 2012

My pivot table shows Towns as the Row headings and Month as the column headings. When I do a Chart, I get Towns on the X axis and Months as Y. I want the chart to show all my May data in a stacked column, then all my June data in another stacked column, etc. If I pick "Select Source Data" the options are greyed out. What's a mother to do?

View 1 Replies View Related

Pivot Chart : No Control Of The Axis Format

Sep 21, 2006

I made a pivot chart. On the X axis are days of the year. I would like the axis to give the months rather than the days, because it is easier to read. But when I select the chart's axis, I don't have acces to any "number" sheet in the "Axis format" section. I could just change the scale.

With Selection.TickLabels
.Alignment = xlCenter
. Offset = 100
.ReadingOrder = xlContext
.Orientation = 45
.NumberFormat = "[$-41D]mmmm;@" 'I added this line
End With
ActiveChart.HasPivotFields = False

View 3 Replies View Related

Format Simple Graph Y Axis Of Pivot Chart?

Nov 19, 2013

I have a pivot chart which has one Axis field (Cell Ref2) and one Sum of Values field (which is a table series of percentages calculated from formulas)

I see the graph like I'd expect, but I'm struggling to get it to show percentages rather than basic integer units on the y-axis? Usually I would imagine to just right click on the y-axis : Format Axis, and expect to see something to change the display units, but it is only for hundredths thousands etc rather than a percentage ? The units themselves in the table for that value series are in percentages so I don't see why it isnt showing the percentage units in the first place.

View 1 Replies View Related

Incorrect Percentage On Pivot Chart

Oct 20, 2007

If I simply publish the pivot chart, the correct percent values are displayed on the y-axis. However, when I publish it with the interactivty option, the percent values are wrong. For example, the actual value is supposed to be 13.7% but graph shows 46496000.00%. The other oddity is that the table published in interactive mode has the correct values.

View 3 Replies View Related

Pivot Chart Running Total With Year / Month And Day On X Axis

Jul 3, 2014

I have a set of data with values and dates (call the dates 'raw dates'). I have added 3 columns with formulae in them as follows:

Year =YEAR('raw date')
Month =TEXT('raw date',"mmm")
Day ='raw date', formatted as "d".

I have a pivot chart with three Axis Fields. In order they are: Year, Month and Day. This is so that the chart itself has three layers of x-axis names (year, month and day) rather than a whole load of dates which looks messy.

I would like to show the values as a running total "in" the raw dates of the data.

When I show the values as "Running Total in" 'raw dates', I get a load of #NAs in the pivot table because the raw dates are not in the Axis Fields. If I select Running totals "in" the Days (which is included in the pivot table setup), I get running totals over each month, starting at zero on the first date in each month. I need to have the running total run over the course of the whole data set, not mini running totals in each month.

When I choose only the 'raw dates' in the axis fields (i.e. taking out Year, Month and Day), running total works fine. The only thing is that I lose the nice looking x-axis. Adding the raw dates to the other 3 Axis Fields also doesn't work - it doesn't even try to give a running total at all, just the original values.

how to achieve a running total without sacrificing the x-axis?

View 1 Replies View Related

Create Chart With Names In Vertical Axis And Values In Horizontal Axis?

Mar 1, 2014

I have a spreadsheet with golfers handicaps, golfers names down the left in column A in rows 3-35. Row 2 has the event numbers titles 1 to 18 (18 events in a year). i need a graph that has the person as the vert axis and the horizontal axis needs to be the event numbers, so i can read down for the person and across to see how there handicaps change from each different event. i have attached the data below.

View 1 Replies View Related

Draw Log Chart Or Edit Axis Intervals And Starting Axis Value

Apr 20, 2007

I have some numeric data that has to be put on a log chart. but there is no option for log charts. 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. whenever i change the value it gets back to its default value,ie 1. can anyone tell me how to draw log chart or how to edit axis intervals and starting axis value?

View 6 Replies View Related

Second Category Axis & Value Axis To Current Chart

Sep 27, 2006

how to incorporate another category and value axis to my existing chart.

1. I need to add a rank axis derived from my data column (C6-C15). This column should rank from highest to lowest and create a tie if any number is repeated. I have arranged the rank column in cells B38:L38 as they would appear. I would like this to appear on the top or bottom of the bar graphs.

2. Second I need to add the frequency of hits which = 3 derived from cell J1 This should appear on the chart were it is currently titled. This should create another bar graph colored green and labeled 3.

3. Lastly the numbers axis can remain the same as it appears on the chart or if it would be better to align as shown in cells B43:L43.

View 5 Replies View Related

Horizontal And Vertical Chart Axis As Value Axis

Jan 26, 2008

What is the best way to have both horizontal and vertical axis as value axis?

View 2 Replies View Related

Add Shades To A Shape Which Shows A Percentage?

Apr 16, 2014

I'd like to add shades to a shape which shows a percentage of remaining solution as the percentage fluctuate the shadow percent does also.

View 10 Replies View Related

Conditional Format The List So That It Shows The Lowest Percentage In 'green' And The Highest In 'red'

May 13, 2009

I have a list in column A of percentages (to 4 decimals 0.0013) i need to conditional format the list so that it shows the lowest percentage in 'green' and the highest in 'red'.

View 5 Replies View Related

Paste Decimal As Percentage?

Nov 7, 2013

I have a source spreadsheet with a bunch of percentages as numbers, like this:


When I paste that into my end spreadsheet with its cell formatted as percentage, I get this:


Which I understand why... I have been searching and all I can find to do is past special with the multiply operation (from a blank cell that contains .01) and then it converts them to the correct result, then I reformat the column as a percentage.

View 4 Replies View Related

Convert Decimal To Percentage

Jul 8, 2009

Is there a method to automatically convert a decimal to a percentage?

For example:

if given the value of 76.48, is it possible to automatically convert this to 76.48%? Formatting the cell as a percentage produces 7648%. I've tried everything I know and can't get the right result.

View 2 Replies View Related

Basic Chart: Set A Chart Up With The Time Been On The X - Axis

Aug 1, 2007

I got a set of data which is only 2 colums collecting data problems. The output i get is a time stamp and a fault. Im looking to set a chart up with the time been on the X - axis and number of problems per hour on the Y - axis.

View 7 Replies View Related

UserForm - Format Textbox For Percentage Vs Decimal?

Dec 20, 2012

I have the following code

Private Sub ComboBox1_Change()
TextBox1.Text = Range("P" & UserForm1.ComboBox1.ListIndex + 3).Value
TextBox2.Text = Range("N" & UserForm1.ComboBox1.ListIndex + 3).Value[code].....

In TextBox3, the user will input a percentage as a whole number, IE: 5 for 5%, but when the update is made, it is writing the "5" as 500% and is writing 50 as 5000%.

If there is already a percent in the cell it calls up IE: 50%, it shows up in TextBox3 as .5%

View 1 Replies View Related

Format All Percentage Cells To X Decimal Places

May 17, 2008

I would like to do the following: * Format numeric cells (cells with a percent sign) to zero decimal places. I have a set of macros that I am combining to clean up a data set and these are two of many (removing blank lines, duplicates, blue/bold, etc.)

View 2 Replies View Related

Chart Menu Bar Always Shows

Aug 9, 2006

I need some vba code to

a) determine which of excel's menubars is active (Worksheet Menu Bar or Chart menu Bar)

b) delete the controls ie File, Edit, View etc menus from that menu bar

c) restore the controls to that menubar on workbook close

Normally this wouldn't be required but my version of excel is 2002 which has the Worksheet Menu Bar active and the work version is excel 2000 which has the Chart Menu Bar active.

I don't know why the Chart Menu Bar is active on the work system as there are no charts in my project.

Most of the development takes place at home so i need to be able to use vba to perform the above tasks

The menubar itself must remain active so i can add a custom menu to it.

View 4 Replies View Related

Pivot Table With Dynamic, Updatable Chart, But Not A Pivot Chart!

Dec 19, 2008

My boss wants me to design a dynamic, updatable chart in Excel 2003. I initially made a Pivot Chart based on a Pivot Table which worked perfectly, but it doesn't look professional enough when printed (or viewed) and she wants me to approach it a different way.

So, I created a graph based on the data in a Pivot Table, and used dynamic ranges as the source for the graph series so that the chart updates when the criteria fields are changed for the Pivot Table. I then added two combo boxes (ie data validation lists) to the Chart sheet, and wrote VBA code so that whenever the combo box values are changed, the Criteria fields for the Pivot Table on the 2nd sheet are updated accordingly, and this in turn causes the graph to be updated as well.

This solution also worked perfectly, but now I've been told to create the graph without macros.

Does anyone have any suggestions? The requirements/details are as follows:

1. The Pivot Table is on sheet "PIVOT", and the graph is on sheet "GRAPH"
2. The Pivot Table has two criteria - School Name and Year Level
3. On sheet "GRAPH" there are two data-validated fields, School and Year, which only allow the selection of valid Schools and Year Levels

Is there any way to make the Pivot Table update when values are changed in the fields on the CHART sheet so that the chart also updates, but without using code nor a Pivot Chart?

View 9 Replies View Related

Column Chart With Line Chart And Percentage?

Sep 15, 2014

In the attached file I have the data which shows me the market size in value, my market share in value & I did a calculation to get the percentage. 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.

View 3 Replies View Related

Pivot Chart Object: Find Any Suitable Object To Choose From To Make A Pivot Chart In Powerpoint

Mar 21, 2007

1) i have office 2003 on a laptop. within powerpoint, i can create a 'microsoft excel chart 11' object. to create a link to the excel data source, do i have to go through the odbc sql setup? it works, but i don't want my powerpoint to be dependent on some excel file somewhere. what are the other options to insert/make a functional pivot chart in powerpoint with the data also within powerpoint? the data as sheet option does not result in the chart being a pivot, it's just a plain chart. it has to be a proper object, not an image paste or a chart that updates links with the excel file open.

2) i have office 2007 on my other laptop. i can not find any suitable object to choose from to make a pivot chart in powerpoint. what's the best way to go about in 2007 version?

3) am i going about this the wrong way with the objects? should i be after vba code?

View 4 Replies View Related

Chart That Automatically Shows Last 12 Months Of Data

Mar 5, 2014

See attached file. I have managed to work out how to update a chart automatically when a new row of data is added. However is it possible to tweak the formulas I am currently using so that it will only include 12 months previous.

For example if you add Jan in to row 26 the chart will show Feb-Jan data (Row 15-26).


View 3 Replies View Related

Pivot Table - Shows Field Name Before Value

Jun 19, 2012

I want to show the field name (i.e Surname) before the value is shown in the Pivot Table. for Example if the Field is Surname and the value is 'Smith', I want to show - Surname Smith

View 1 Replies View Related

Pivot Table Shows Text As Value?

Jun 28, 2013

I have attached my workbook, it is a pretty standard pivot accross 3 sheets but it is only showing values instead of text, how can I change this? I have tried everything.


View 6 Replies View Related

Chart In Spreadsheet That Shows Number Of Claims Per Defect

Dec 31, 2006

I have a chart in my spreadsheet that shows number of claims per defect. Is there a way to format this bar chart so that it will only show the top 5 automatically, even when they are constantly changing? There are a total of 13 different catagories.

View 9 Replies View Related

Chart With Two Axis

May 17, 2007

I have some simple data and i want to create a horisizontal bar chart with 2 axis (X axis) the top one showing number of stocks number up to 270 and the bottom with Market Cap up to 1,200. (See attached). I set up the chart and it looks fine but it has only one axis so in order to create a second axis i right click on the blue series (no of Stocks) and go through the motions of setting up a secondary axis. However when i do that it ends up looking like the chart to the right with the Bars Cojoined (which is not what i want) I cannot seem to achieve 2 axis with separated bars

View 3 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved