Hi

I have a pillar diagram whit 6 different values. Value names are:

A-MUX, A-MUX(kk), B-MUX, B-MUX(kk)..and so on

I'am trying to do that A-MUX and A-MUX(kk) pillars are closed together. And after that is a little space and B-MUX and B-MUX(kk) pillars are together and so on.

How this should be make?

Hope you understand what I mean=)

I have a pillar diagram whit 6 different values. Value names are:

A-MUX, A-MUX(kk), B-MUX, B-MUX(kk)..and so on

I'am trying to do that A-MUX and A-MUX(kk) pillars are closed together. And after that is a little space and B-MUX and B-MUX(kk) pillars are together and so on.

How this should be make?

Hope you understand what I mean=)

- How to correctly scale X-Axis in Charts?
- How to make "secondary x axis labels"
- Scaling x axis for Bar Graph
- How chart time scale x-axis with another date serie
- VBA to remove chart X-axis label
- Trying to combine 2 columns of data to create one x axis in graph
- Setting x axis scale to time with variable intervals
- How to use two X axis
- How to make a menu selection in the same cell?
- How to make X equal total?
- How do I switch the axis values in my chart
- How to make a transmutation table
- How to make multiple links within a paragraph work
- Need to make certain text bold in a comment using vba
- What chart to use, how to set up data table?
- How can I make a chart with the x-axis in logarithmic scale
- Converting X-axis from exact numbers to a scale
- Make secondary x-axis logarithmic using VBA
- X axis scale on an XY scatter plot
- How to Make Nomograms
- Trying to make a log-log graph
- Create a scale x axis that matches the straighted form of a norma.
- How to show long x-axis label in two lines?
- Trying to make a log-log graph

I have the following data to plot:

01/31/95 0.29623

12/29/95 0.19822

12/31/96 0.13931

12/31/97 0.33036

12/31/98 0.082194

12/31/99 0.23669

12/29/00 -0.25575

12/31/01 0.023404

12/31/02 -0.11949

12/31/03 -0.018228

12/31/04 0.12326

with the dates being the actual dates I wish to plot on my x-axis in a regular Excel line chart. As you can see, they are irregular dates. Regardless of how I try (with ensuring the Minor Unit is on Days and the Major on months), I can't seem to get the right combination to have Excel plot the actual dates above. Instead, it seems to keep defaulting to the last day in January, probably due to the first data point in the date series or it just gives me a regular monthly date by year (always January 1, XXXX for instance).

Does anyone have any ideas how I would fix this to get the actual dates above to plot on the x-axis?

Thanks,

-Pete

left hand axis and one on the right, but with a common x axis

but is there an easy way to have two x axis, one at the top and one at the

bottom. i don't actually need a 2nd series, but I want my charts to have one

unit across the bottom (dose) and another along the top (exposure index)

just for reference, so that visually I can look at the curve and read off

either dose (at the bottom of the chart), or exposure (at the top)

thanks in advance

I am new to using excel and I am trying to figure out how to make the x axis on my graph scaled at even intervals. I am using a bar graph, which is categorical- I am sure this is part of the problem.

Attached is the file I am working on. The X axis represents depth, and the y axis represents fish observed (at the the depth).

I am sure there is a quick way to automatically scale the x axis. Any assistance would be great! Thank you!

know how to.

Serie 1 is below which needs to be time scaled

Date Count

1/1/2006 12

1/2/2006 3

1/3/2006 5

2/1/2006 18

2/3/2006 4

2/18/2006 9

4/1/2006 18

7/4/2006 38

Serie 2 - needs to plot the three dates in serie 1's time scaled X-Axis with

symbols.

1/31/2006

2/18/2006

4/2/2006

I will look something like you have a line of count on a time-scaled chart,

with 3 dates point in the x-axis. Please give me some advice on how to do

it. Thank you all.

Here's my chart code

VB:THanksCharts.Add ActiveChart.ChartType = xlLine ActiveChart.SetSourceData Source:=Sheets("Sheet2").Range("E" & CurrRow & ":" & LastCol2 & CurrRow), PlotBy:=xlRows ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet3" ActiveChart.Parent.Name = "CHART" & CurrRow ActiveChart.HasDataTable = False ActiveChart.Axes(xlValue).Select With ActiveChart.Axes(xlValue) 'the min/maxscale makes the Y limits 150 to -150 .MinimumScale = -150 .MaximumScale = 150 .MinorUnitIsAuto = True .MajorUnitIsAuto = True .Crosses = xlAutomatic .ReversePlotOrder = False .ScaleType = xlLinear .DisplayUnit = xlNone End With ActiveChart.Legend.Select Selection.Delete ActiveChart.Axes(xlCategory).AxisBetweenCategories = FalseIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

create an Asthma peak flow chart and have 4 different times per day with

figures - before & after), so each day has 4 lines. I need to show data and

graph (if possible) on one sheet to take to the hospital. At the moment the

column is too long to be readable in landscape (with graph) and I can't find

a way to change orientation of graph to make it readable in portrait. Is

anything possible (my dates are like 01 8, 01 12, 01 16, 01 20 etc. for

every day in the month).

an area chart. If i use x-y scatter, the x-axis spacing is correct (points

are proportional to the time), but i can't get an area chart. If I use the

area chart, the observations are all spaced equally along the x axis.

Does anyone know how to make the x-axis plot time for normal charts?

I am trying to get another x axis on the right hand side of this graph with %.

The bars represent the money values in the table, how do i get the % values also into the table but shown as a line. I have tried playing around with it, but the graph just becomes distorted.

Many thanks for your help.

Help.xlsx

for me...its a simple column graph.

I know how to make just a link in a cell work by just entering the link and pressing enter. But i now have a paragraph in a cell that has multiple links within the text. How can i make the links work?

For example,

I have in a single cell....

"If you need to do a search on google, www.google.com and the other option would be yahoo, www.yahoo.com"

Please help. Thanks!

Untitled.jpg

I've searched other forums and none have helped. I need to do this in vba. Thanks in advance.

I have the following data. What chart should I use to display it most effectively?

How do I set up the data table for it? I tried using a scatter plot, but couldn't figure out how to make the X axis be the employee names.

Employee Commission

Dave 1.3

Dave 0.3

Steve 2.5

Dave 9.4

Al 3.2

Bob 6.1

function makes the y-axis log

I'm trying to make a line graph based on two sets of data. These are a subset of the data:

Distance Moran's I

57.302 0.33

143.568 0.084

198.755 0.009

248.781 -0.059

296.452 -0.063

342.166 -0.061

386.37 -0.051

I want the Moran's I data on the Y-axis and the Distance data along the X-axis, which I've been able to do easily using a PivotTable/Chart. However when I create the chart I can't seem to change the X-axis data from the exact number, i.e. 57.302, 143.568 etc to a scale e.g. 0 100 200 300 400.

Anybody know how to change the X-axis so it's displaying my data in a scale rather than the exact numbers?

Many thanks for the help

Ben

I'm writing a macro that automates creation of a scatterplot, and I need to make both the primary and secondary x-axes logarithmic. However, whenever I try to set the .ScaleType property for either x-axis through VBA using the lines of code given below, I get an error that says "ScaleType of object Axis failed."

VB:I am aware that the .ScaleType property technically only applies to the y-axis, but I found out from some old posts in another forum that this error will not get raised as long as .ScaleType is set immediately after all data has been added to the plot. This solves my problem for the primary x-axis, but it is impossible to set this property for the secondary x-axis immediately after all data is added to the plot because I have to add the secondary axis before trying to make the scale logarithmic. Is there another way to get around this?ch.Axes(xlCategory).ScaleType = xlScaleLogarithmic ch.Axes(xlCategory, xlSecondary).ScaleType = xlScaleLogarithmic 'Note that ch simply refers to the chart that's being createdIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

I have created an XY scatter plot with date values on the x axis, the

problem is that my data starts in 1971 yet the x axis goes back to

1900. I cannot access the check box to make the x axis time scale as it

is greyed out in the chart options form.

I have made a bit of a mess of describing my problem but if anyone has

come accross this before or knows how to get an XY scatterplot to

automatically start its x axis values with the minimum x value given to

it, I would be grateful.

I can fix this using vba but I would rather not.

Regards,

Tim

Y-Axis with two scales of values, another Y-Axis with one scale, and two

X-axis each with 1 scale of values.

so that i have the Y-Axis with 2scales on the left, the Y-Axis with one

scale on the right, then one X-Axis on the top and one on the bottom.

thank you.

change the x axis to log scale. Its not an option in the "format axis"

window, and I have no clue how to go about doing it. I'm using Excel 2000,

and the data range for the x axis is from 9.35E-4 to 2.40E-3.

Thanks

distribution curve such that when this curve is ploted on this graph, the

scaling makes the cure turn into straight line. Logarithmic x scaling doesn't

work for this. How else can I achieve this?

Thanks

JOhn

I am doing a column chart. All x-axis labels are quite long. Is there

any way to show them in two lines?

I tried to adjust orientation in the option(alignment), but the chart

will be too ugly.

Thanks

Kelly

change the x axis to log scale. Its not an option in the "format axis"

window, and I have no clue how to go about doing it. I'm using Excel 2000,

and the data range for the x axis is from 9.35E-4 to 2.40E-3.

Thanks