I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial...

Does anyone know how to make a nomogram in Excel? I am trying to get a Y-Axis with two scales of values, another Y-Axis with one scale, and two X-axis each...

I have two questions: Why is my chart showing extra bullet points at zero beyond the 11 bullet points that I want? How do I get them off? I was going to...

Help! I want a line chart that only shows data points, not lines in between. A scatter chart doesn't work correctly with the data. How do I remove the...

Parallel discussion: http://www.mrexcel.com/board2/viewtopic.php?t=69951 -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint,...

Excel charts are not visible when they are located in chart sheets. They become visible when certain printer drivers (e.g. Microsoft Office Document Image...

Hi. I am trying to create some "MARKERS" at the top of a line chart. I'm using a series as a line to mark the top of the graph. The purpose of the markers...

How do I create a chart which shows both a total number of bookings & the total revenue matched against months of the year. e.g: Months Total Bookings ...

I have a large workbook with about 30 charts each on a seperate worksheet I manually name the charts be changing the tab names. sometimes when I reload the...

I'm creating a large workbook with master data on one page and on all following pages Pivot Tables with associated Pivot Charts, one worksheet per state, 4...

how can i add trendline or best fit line on a scatter plot which has multiple set of data. for example, i had 3 set of data for 3 different depth (0cm,15cm and...

Hi, I have a Pivot Table with 6 data types. 1 has a wide scale, say 1 - 100,000. The other 5 data types have a scale that is narrow, say 1 - 20. After I...

In excel 2007 my charts are displayed when inserted in a a sheet but they do not show when moved as separate tabs

I copied text, values and formulas from one workbook to another. When I tried to chart some of the data, the chart insert chices were grayed out. It...

Hi, I faced this problem and found a solution but you need to use macro. Sub AutoScaleYAxes() Dim ValuesArray(), SeriesValues As Variant Dim Ctr As...

Hi, I have a lot of data in which sometimes data varies too much that some bars raise up to 1000s and some remain within 100s. now, to overcome this problem...

I am trying to create a line chart but am having trouble with labeling the X-Axis. The graph is charting temperature on the y-Axis and the date and time of...

how to create a plot from separate x and y values. i.e. y values do not correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15

How can I put decimals in my pie chart - such as 98.34%?

I'm creating a graph from a series of values in one column. In the adjacent column I have the date the value is entered. How can I get these dates to...