graph chart

Hello, I'd like my graph to look exactly like the graph I pictured below. I'm trying to create an area graph to shade each range percentage listed below a different color. Rage A - shade anything above 15% Range B - shade 5 - 15% Range C - shade -10 - 5% Range D - shade anything below -10%...

Hello everyone! This is my first post so I'm sorry if I've made a mistake: I'm trying to create some bar/line/pie charts within Excel using data from a survey. However, one of the questions that was imported over has multiple answers within the same category (see column E in fake sample...

Hi guys This issue at first seemed really simple but I have been at this for hours and cannot make any progress. I have search a ton of articles, boards and all the solutions posed do not fix the issue i am facing, which is to place the secondary Y axis (which is a calculated field, showing...

Hi everyone, I'm trying to make a graph on the base of data which I get from a external source database and what I need to know that is there a possibility that the graph auto scrolls to the current value and work like a real time graph and if not then can it be achieved through VB Code. Any...

When I switched from Access 2013 to 2016 all of the charts that I had previously created changed to a smaller size in every form. How to I resize these back to the normal size they were before? I utilized two versions of Access because of a customer need for different versions from 2013 to 2016...

Hi! As shown in the picture, I am comparing year end sales numbers (in millions) with stores numbers. Since Sales are in millions, the bar graph displays store numbers are more than sales. How can I display it so that it is easy to compare visually?

I recently found a solution to display date in Graph on userform from John Walkenbach. I was curious and really want to add a feature to be able to change the divison value in x axis or Y axis. If for example the divison is 0-10, and if I want to increase the divison from 0-10 to 0-20, then...

I am trying to make a graph that changes colors when it reaches its target. I.E. Below Target = Green Above Target = Red. I have the data set up in three columns, <=Target, >Target, and Target. The formulas I have are =IF(U121<=CF121,U121,NA()) and =IF(U121>CF121,U121,NA()) My problem lies...

Hello everyone, I would like to create a bulls-eye type graph, but instead of a single line I want to make bands, or regions (zones) that would highlight areas such as 10% to 20% is green, 20% to 35% is yellow, and +50% is red. I was previously asked asked to create a few bulls-eye graphs for...

I will try my best to explain my problem. I have the following data: <tbody> SD(minus) Mean SD(plus) Points A 19.1 28 36.99 39 B 7.92 12.6 17.28 10 C 14.04 19.7 25.36 25 D 10.68 16.1 21.52 15 E 7.68 12.4 17.12 17 F 7 9.5 12 13 </tbody> I have to now plot the...

I know there are lots of articles and videos on this title. But I have search a lot all over the internet and has not found what I am looking for. I will try to explain with an example. Any help is greatly appreciated. Example: <colgroup><col><col><col span="3"></colgroup><tbody> Category...

Hello, I have a spreadsheet, that has a graph chart. There is two sets of data within it, with 2 data sources. Within the Select Data Source, I have the two Legend Entries (Series) listed, which I want to be dynamic the Horizontal (Category) Axis Label will be static, as the data here is the...