axes

Help! I've got a large model with 30+ charts. They were created in XL2013 32bit, I've now got 2016 64bit. When I try and amend the bounds (upper or lower) for the secondary axes, all the chart elements (series, axes, legend) disappear and I get left with a blank chart. I tried deleting the...

How can I graph two lines of data into bars that share the same x axis, but different Y axes and are not stacked. The alternate is to make one of them a line graph, but in the case I need them both as independent bar graphs next to each other and referencing different y axes. Thanks in advance...

How do I create a line chart with two different sets of x and y axes ? i.e I have data set 1 with data on x1 and y1, and data set 2 with data on y1 and y2. Currently excel seems to ignore the distinct x axes ? thanks kind regards Kaps

Hello I am using Excel 2010. I have a worksheet with a pull down list of hospitals. I've locked up all objects and charts on the worksheet but when I select a new hospital, I get a run time error of "method maximumscale of object axes failed". I should point out that I have two sites on one...

So most charts plot a positive X and positive Y and look kinda like this: Others have negatives - so the zero point is in the center, where the X and Y axes intersect: Do these two different graphs have different names? Like, if I said I wanted a "transgential interspecular graph", a...

Hi, I have a list of children names in A1:A20, and their heights in B1:B20 - 0.8, 1.24, 1.3, 1.47, 1.56 etc.. I would like to create a chart (or other visual option) that will draw horizontal lines on Y axes to represent the heights proportionally: 1.56------------------...

Hi... I am new to this site.. and posted a question back in June.. I haven't gotten a single response... how do you get help on these Forums? My thread was called "Method Axes of object Chart Failed" There were 49 views.. maybe others have the same issue and looked for resolutions, I don't...

Hi, I've got a spreadsheet connected to a tabular model running on SQL Server Analysis Services. I am creating pivot tables / pivot charts with the row field as months. I've defined two measures - billed orders per day and quoted orders per day. Both measures are similar in magnitude (i.e...

Hello All, I deal with sending data to customers so I need my graphs to look similar. I wrote a routine to make a chart page look consistent starting back in Excel 2007. I am now at Excel 2016 and I needed to update my macros for compatibility. All charts must be XY Scatter. The code works...

I have a simple bar chart in excel 2010. Sorry I can't post a picture of the chart at the moment. The data included in my chart comes from the below table : <tbody> Supplied Data Levels Forename Surname D.O.B House Num Postcode Valid Phone Number Benchmark 0% 100% 0% 100% 100%...

Hi there, I have 2500 unique location rows in the first column with 5 additional columns. Each additional column contains a different metric value. Is there any current excel technique which could be applied to plot all 2500 locations in a graph containing 5 different axes? Looking for a way...

Hi, I have a single data series (one set of x values) that I want to plot with two sets of y values (two axes). I've tried creating a second series with the same x values and new y values, then setting the series to a second y axis, but even with scales that have the same number of...

Greetings, I'm trying to condense some charts, and I'd like to show just the first/last (beginning/ending) axis labels, not the values at each tick mark. For instance, if my axis now reads 0, 5, 10, 15, 20, 25, I want it to just have 0, 25 (keeping the tick marks). Can anyone tell me a way...

i want to write a code that generates data and add a chart. i tried recording a macro (subroutine) but i read that excl2007 has problems. so the x values go from 1-100 on column A and y=(2*x)+7 on column B. then from this data i want to add an xy scatter with smooth lines. then i want to format...

I can change the color, size, etc. of the axes colors manually - can this be done via VBA? I see how to set the value where it crosses, tick marks, etc. I am using Excel 2007 Thank you.

I am trying to format a chart in excel using VB. I would like to be able to format the axes of the chart based on a cell value -- the X-axis value is in cell "chart1info!$B$4" and the Y-axis value is in "chart1info!$C$4" for instance. I tried recording a macro for formatting the axes and got...