Hi,
Just purchased the program and am trying to figure out how to make a bar graph with 2 y axes and data sets that have non-numeric x-labels. For example, I want to display information about stages of a treatment process of two different chemicals with very different concentration levels (hence the need to scale the y-axes differently). The data might look something like this:
Treatment ChemA ChemB
Influent 10000 20
Main Tank 8000 15
Sand Filter 3000 14
Wetland 2500 2
Effluent 2000 1
So I want to display each treatment stage on the x axis and show the concentration on 2 y-axes. How do I do this from Excel? (I keep getting error messages (run-time error 13; type mismatch).
Bar Graph, non-numeric labels
Moderator: DPlotAdmin
-
DPlotAdmin
- Posts: 2312
- Joined: Tue Jun 24, 2003 9:34 pm
- Location: Vicksburg, Mississippi
- Contact:
There's no way to do this directly and it will require a bit of tedium. I'll add to my to-do list a new Add-In function to automate this.
Select your 1st Y column only, then select XYYY. This will give you an XY plot with X values starting at 0 and incremented by 1. Switch back to Excel. On the DPlot menu, select Options and ensure that "Append... " is checked. Now select your 2nd Y column and, again, XYYY.
In DPlot click on any of the numbers on the X axis and select "None" for the number format.
Right-click within the plot and select "Bar Chart".
Select Text>X,Y Labels. In the first row set "X/Y Value" to 0, "Label"=Influent, "Location"=X bottom, Offset=0. Repeat for X=1-4.
Select your 1st Y column only, then select XYYY. This will give you an XY plot with X values starting at 0 and incremented by 1. Switch back to Excel. On the DPlot menu, select Options and ensure that "Append... " is checked. Now select your 2nd Y column and, again, XYYY.
In DPlot click on any of the numbers on the X axis and select "None" for the number format.
Right-click within the plot and select "Bar Chart".
Select Text>X,Y Labels. In the first row set "X/Y Value" to 0, "Label"=Influent, "Location"=X bottom, Offset=0. Repeat for X=1-4.
Visualize Your Data
support@dplot.com
support@dplot.com
David,
I have been meaning to ask you about the possibility to add Excel-type "Line Graphs" to DPlots capabilities. I think this fits in with bstanfor's request. I realize DPlot is primarily an x-y plotter, but all the Excel line graph does is assume an equal spacing. It may be a numeric x-axis, or it may be labels only, but the assumption is that whatevey "y" is, it gets plotted in equal increments over the available plot space. It would be great if DPlot could do this with the add-in, simply by picking the correct entry on the add-in menu, ie, "YYY Line Graph" or such.
I'm thinking that DPlot would intervene with a dialog box for the user to fill out, asking the user if the x-axis is some implied spacing and units. Then Dplot would calculate the assumed spacing and proceed with the plot.
I realize one could set this up correctly, as in your suggestion to bstanfor, but for some of the users we have here, it would be better if Dplot could do this for them
The reason I ask, is that DPLot is such a great improvement over Excel plotting, that I find myself trying to see if DPlot can plot the same data (as easily). Then I can use DPlot to turn curves on and off, zoom and pan, etc. You just can't do that in Excel.
I have been meaning to ask you about the possibility to add Excel-type "Line Graphs" to DPlots capabilities. I think this fits in with bstanfor's request. I realize DPlot is primarily an x-y plotter, but all the Excel line graph does is assume an equal spacing. It may be a numeric x-axis, or it may be labels only, but the assumption is that whatevey "y" is, it gets plotted in equal increments over the available plot space. It would be great if DPlot could do this with the add-in, simply by picking the correct entry on the add-in menu, ie, "YYY Line Graph" or such.
I'm thinking that DPlot would intervene with a dialog box for the user to fill out, asking the user if the x-axis is some implied spacing and units. Then Dplot would calculate the assumed spacing and proceed with the plot.
I realize one could set this up correctly, as in your suggestion to bstanfor, but for some of the users we have here, it would be better if Dplot could do this for them
The reason I ask, is that DPLot is such a great improvement over Excel plotting, that I find myself trying to see if DPlot can plot the same data (as easily). Then I can use DPlot to turn curves on and off, zoom and pan, etc. You just can't do that in Excel.
Bar Chart, Multiple axes
David,
Thanks for the tips...not really all that tedious but an add-in would be great. If anyone else needs to do this, I'd just add that placing the X/Y value to increments of 0.5 instead of 0 (1) makes the placement of the labels a bit nicer in terms of appearance. Otherwise it works great. Thanks again!
Thanks for the tips...not really all that tedious but an add-in would be great. If anyone else needs to do this, I'd just add that placing the X/Y value to increments of 0.5 instead of 0 (1) makes the placement of the labels a bit nicer in terms of appearance. Otherwise it works great. Thanks again!