how do you create a graph with a field such as vendors on the X-axis, but with dollar values spent on the left side of the y-axis and percentage of total dollars spent on the right side vertical axis?
View 3 Replies
Is there a way to show the Vertical axis on both right and left side of the graph or at least on the Right hand side?
View 5 Replies View RelatedI 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 RelatedWhat is the best way to have both horizontal and vertical axis as value axis?
View 2 Replies View Relatedis it possible on a line chart to move the vertical axis to the right side? or perhaps show it on both the left and right?
View 2 Replies View RelatedI am tasked to plot some client satisfaction data on a monthly basis. I want to be able to show the client satisfaction with different aspects of service delivery. Can have a chart with "Good", "Fair", and "Poor" on the vertical axis with months on the horizontal axis?
View 1 Replies View RelatedTwo graphs with different scale x-axis.
Graph No. 1 with smaller time frame, Daily.
Graph No. 2 with larger time frame, Weekly.
Objective: Add vertical line to mark the same times in both graphs.
Trouble is both graph already utilise the secondary axis. VBA is allowed.
I would like to create a chart with stacked columns. Usually, the data on the Y-axis is some kind of numerical data, such as budget. I would like to have the Y-axis have non-numerical data (= nominal categories).
Example :
Take the following data :
category | productname
red berry
red carrot
green cabbage
green apple
The ouput format i want is a chart which shows on the horizontal axis the categories red and green, and stacks in each category the right productnames on top of eachother; preferably each productname should have a different colour and showing data labels (e.g. "1", "green","apple" could be 1 specific data label).
I don't know how to achieve this, because if you display data as "count of productnames", then automatically you get something like a block with value 2, which doesn't show the different productnames inside that block.
Can the desired chart be made with Excel somehow?
I am having a problem formatting a chart in Excel 2010. My chart has multi-level category axis labels, and I would like to have a vertical grid line separating each major group of categories. In Excel 2003, I could right-click on one of the gridlines and then specify the spacing I wanted between gridlines. In Excel 2010, as soon as I indicate that I want multi-level category axis labels, I get a vertical gridline between each category and I am unable to alter the spacing. If I deselect the multi-level axis label option, I can adjust the spacing between the vertical gridlines, but the axis multi-level label functionality is lost. Is there a way to fix this problem without having to resort to using the drawing tools or text boxes to achieve the desired results.
View 3 Replies View RelatedTwo questions:
1) How do make values on x-axis as words? E.g. apples, oranges, etc.
2) Is it possible to have the numbers on x-axis in descending order? If I can figure out 1), I can do this as well, but it would be nice to know if it is possible to have the numbers on x-axis in descending order.
I need to create a graph with a 2 x axis and a single y axis. For example:
Pressure ( PSIA) Solubility (mol %) Velocity (m/s)
200 0.024 1
300 0.036 1.2
400 0.041 1.8
I need the two x axis to be pressure and solubility and the y axis to be velocity, with the data being demonstrated by a single plot (I have only managed it with two plots which does not demonstrate solubility's relationship to pressure ).
For example at a pressure of 200 PSIA (lower x-axis) and solubility of 0.024 mol % (upper x-axis) velocity was found to be 1 m/s.
I would like to add a vertical axis to the right of my plot that looks exactly the same as the left axis. The only way I found to do this is to add a secondary axis. However this axis is based on a data series and it does not match the left axis.
How can I make the left and right vertical axis look the same.
Is there a way to make the bar on a vertical column bar graph increase in height gradually over a couple of seconds rather than jumping from one height to the next height instantly.
eg:
if a vertical bar graph is reading data from cell b5, and b5 currently reads as 46, if b5 then changes to (let's say) 58, I'd like the column bar graph not to instantly change from a height reflecting the 46 to a height reflecting 58, but to slowly rise, showing the transition from 46 to 58.
I have a normal line graph I would like to see plotted vertically rather than the normal horizontal layout. In other words, points/lines would appear around a vertical axis and go from side to side. The normal graph would look as if it was tipped on its left side.
I've put together code to construct a chart
It all works fine but I've noticed an odd quirk which I can't explain nor can I seem to fix. Here's the (reduced) code :
Code:
Dim appExcel As Object ' Excel Application
Dim chtPareto As Object ' Chart
Set appExcel = CreateObject("Excel.Application")
Set chtPareto = appExcel.Charts.Add
With chtPareto
' Primary category axis
[code]....
The category (x) axis title should be horizontal, whereas the value (y) axis title should be rotated. Stepping through the code, when I .SetElement for the category axis title, it appears horizontal as planned. However, as soon as I .SetElement for the rotated value axis title, the category axis title also rotates.
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 RelatedI am able to change the X-Axis with:
Code:
ActiveChart.Axes(xlCategory).TicketLables.Orientation = 45
How I change the Y-Axis?
I am trying to add a secondary axis for a graph but it is not displaying as it normally does, instead of the columns remaining side by side they overlap. I don't normally have any issue with this so I'm not sure what I'm doing wrong. I've attached images to show what i mean.
Before I add secondary axis
After adding secondary axis
how can i make a graph "like a line graph"
to have multiple value axis's?
how to plot Multiple left Y axis display in Multiple draw line graph. Already I have created Right Y axis. I want to draw 4 Line graph in one graph 3 are Left Y axis and one is Right y axis.
View 1 Replies View RelatedThere is probably a really simple solution to this, but I have a column 'A' of data, with various numbers, and a column of data 'B' with letters from A to Z. However when I try and plot this on a scatter graph, the x axis uses numbers rather than letters, with data points all over the place?? I'd like the X axis to have the letters A to Z, and the data to stack up vertically when there is a few different numbers correpdoing to 1 letter. Specifically, a scatter graph
View 3 Replies View RelatedOn my graph the bottem axis shows 1-30, I'd like to change this to 30-1 as I track change over the last 30 days. I tried selecting reverse axis but it reverse's the data as well. Is it possible to change the axis text only, eg latest entry will be one and the 30 day old data will be 30.
View 2 Replies View RelatedHey guys, been searching around for a while now, yet to find an answer to this.
I have 3 columns of data ......
I have a line graph that contains information for the following products,
Boats , Cars & Bikes.
The chart works well but i would like to show the numbered scale of each product & i can't work out if this is possible in excel.
Currently i can only get two data showing for the axis.
I would like to show all three & just use a color to indicate which data corresponds to which product.
In my attached example: I have data for both Cars (blue) & Bikes (green) but i would like to also show data for the graph scaling for Boats (pink).
I would like to graph the data shown below using a scatter graph. However, when I use the cart wizard it assigns numerical values to each data point and then plots the data accordingly. How can I get the scatter graph to group the assets with the same ratings together? Note, I don't want to have to assign values to assets with the same rating each time. I have attached the spreadsheet so you an see the problem.
View 5 Replies View RelatedI am trying to reproduce a graph similar to this: [URL] ....
How to get the Y axis in the center and two distinct bar charts on either side.
Sample data can be found here: [URL] ....
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.
I have a set of data which I need to plot both unordered and ranked.
For the unordered (as is) data, a line graph is fine, as it gives the category labels along the x axis.
For the ordered data, i have a row with the ranking in, and then plot an xy scatter graph, so the values increase.
This obviously has the rank numbers along the x axis, not the corresponding category labels.
Is there anyway to force this? I know there are chart labelling add-ins on here, but our IT dept blocks the download.
The attched file is a very small example.
I have two vertical ranges that I need summarized into 2 adjacent vertical ranges.
"
A B C D
| SUMMARY
model qty| modelqty
1 4.12922.0000| 4.12952.2000
2 2.000012.1250| 2.000025.1250
3 4.12929.0000| 318.0000
4 318.0000|
5 4.1291.2000|
6 213.0000|
"
A1:A6 is my SKU's model number B1:B6 is my inventory C1:C6 should contain formulas that result in a summary of the models D1:D6 should contain formulas that result in a sum of the inventory count for each model
I'm simply trying to graph my data on a line graph in Excel. see the attached.
The issue is that the spacing on the x-axis is all equivalent. I want the space between the initial and 1st month to be very small while the space between 6 month and 12 month be larger.
So at the end of the day, the line will be kind of crunched down from the beginning and goes up at the 6 month data point.
Is Excel capable of handling such simple request?
