chart 2007

Hi I need to create a chart using excel to track the supplier history prices. To make it easier for you to understand my thread, I'll give an example: let's say the supplier set a prices for a specific product as following: Nov 07, 2017 $30 Nov 15,2017 $20 Dec 20,2017 $29 Now, the idea is...

I have a weird problem printing multiple worksheets, all of which contain charts only. If I try to print all the pages at once by selecting all 10 worksheets (21 pages total), they seem to get broken up into batches. I can't see any logic to it. This happens no matter which printer I am...

Hi All, I have a graph line chart. Broken down by Month (Jan-Dec on the horizontal track) tracking sales for this year and last year. I hate the way the graph looks because since I only have sales from Jan to Jun only the other months are showing zero and the bar graph is showing the zeroes...

Hi Working with a data set of schools in Wales - I have an XY graph showing (for example) free school meals (x) and results (y) for up to 200 schools. << The data is pulled via JSON from a government site - and all works well. I want to be able to click / double click a point on the XY graph -...

Hi :) I have a graph in an excel sheet that depends on several formulas and data... What I need is a code or a formula which asignes Cell B38 the Maximum of the function in the chart ?? Can anyone help me with this?? Thank you!!

Hello, I'm wondering what the best way to chart something in Excel is. My company wants to track our business development by making contact each month with our key contacts and graphing that it's been done. So, I want to graph each month we've contacted 3 out of 6 companies, 5 out of 6...

Hi, Is it possible to set the same scale (e.g. min, max) on both the primary and secondary axis of a chart? If so, does it have to be via a macro? I know it is possible to do it manually, however when we have dynamic data this is an issue... Thank you! Henrique Vieira P.S.: I'm currently...

Hello I am confused..!:confused:Which chart I shall use for representing my data. I need to display graph of number of students scoring grade for each Exam class wise Mean to say - In Exam FA1 students score grade A1, A2 and so on. Now how can I display the graph for the same. <tbody> Exam...

Hi there guys, A question for you on this fine day! I have a line chart for a number of years, but there may not be a figure for a certain year. So, if I have year 2009-2014, in 2011, there may be no figure. I don't want the chart to drop to zero (which it does if I put in a zero). I also...

Hi Everyone, I am an Excel programmer and report builder. So would class myself as quite advanced at excel but something has me stumped. I have been tasked with creating a chart like below. http://s7.postimg.org/om5tw7k0b/sample_chart.png I can create the rankings and place them in the...

In Excel 2007, I have created a scatter chart with around 14 points with captions displayed showing the numeric values. What I want is that when I hover the cursor on each of the point, a text box containing description of the values (aroud 5-10 sentences written on a separate sheet for each...

I am attempting to replicate the chart as seen on page 23 of the JP Morgan Chase earnings release for the financial institution I work for. I am struggling to make it work. I will be happy to send the Excel file if requested. My data is layed out as follows: Column A - Date Column B - Total...

Hi All, Excel 2007 I'm preparing quite a complex weekly report and so I'm making use of dynamic charts based on a number of named ranges. Is there anyway to avoid having to create a named range for each and every series? This is proving somewhat tedious with certain types of chart, such as...

A few months back I was asked to put a spreadsheet together that charts 2 different sets of data, by state and by month. What those sets are isn't relevant to my question since I can handle each set largely the same, but separately. What I put together is functional, but more tedious than...

Hello everyone, I really want to replicate a layout of a chart I found but I can't do it alone. The chart represents some subjects that are rated using a Likert scale (5 points) and 2 participants's answers are compared. A link to the file with the image and my draft is attached...